Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Wed Jun 15, 2011 6:47 pm

Hi,

One of Amazon's seller templates causes exception by opening and saving the file. Link:

https://images-na.ssl-images-amazon.com/images/G/01/rainier/help/ff/release_1_9/upgraded_templates/Flat.File.Watches.xls

Sample Code:
Code: Select all
var workbook = new Workbook();
workbook.LoadFromFile("Flat.File.Watches.xls");
workbook.Save();


Stack trace:
Code: Select all
   at System.ThrowHelper.ThrowKeyNotFoundException()
   at System.Collections.Generic.SortedList`2.get_Item(TKey key)
   at Spire.Xls.Core.Spreadsheet.XlsExternWorkbook.a(RecordArrayList A_0)
   at Spire.Xls.Core.Spreadsheet.Collections.XlsExternBookCollection.SerializeDataToList(RecordArrayList records)
   at Spire.Xls.Core.Spreadsheet.XlsWorkbook.WorkbookExcel97Serializator.a(RecordArrayList A_0, ExcelSaveType A_1, IEncryptor A_2, XlsWorkbook A_3, XlsWorksheet A_4, Boolean A_5)
   at Spire.Xls.Core.Spreadsheet.XlsWorkbook.WorkbookExcel97Serializator.Serialize(String fullName, XlsWorkbook book, ExcelSaveType saveType)
   at Spire.Xls.Core.Spreadsheet.XlsWorkbook.SaveAs(String fileName, ExcelSaveType saveType, ExcelVersion version)
   at Spire.Xls.Core.Spreadsheet.XlsWorkbook.SaveAs(String FileName)
   at Spire.Xls.Workbook.SaveToFile(String fileName)


Tested with 5.8.5.4 (.NET4, standard ed.) and 5.8.0.4 versions.

Please advice.

cordis
 
Posts: 2
Joined: Mon Jun 13, 2011 12:10 pm

Fri Jun 17, 2011 10:12 am

Dear cordis,
Thanks for your inqury.
It's a bug. But we've fixed it.
You can download the latest version-Spire.XLS Pro Edition for .NET (Hot Fix) Version:5.8.7 from http://www.e-iceblue.com/Download/download-excel-for-net-now.html
Justin
Technical Support / Developer,
e-iceblue Support Team
User avatar

Justin Weng
 
Posts: 110
Joined: Mon Mar 28, 2011 5:54 am

Fri Jun 17, 2011 10:45 am

It's working now, thanks!

cordis
 
Posts: 2
Joined: Mon Jun 13, 2011 12:10 pm

Return to Spire.XLS