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.

Fri Mar 21, 2008 4:31 pm

Unable to cast object of type 'br' to type 'kh'.

I get this when I try to open an Excel file saved with Office 2007 as "Microsoft Office Excel 97-2003 Compatible Workbook" (.XLS).

It is not usable in my company if this can't open simple Excel files..

StackTrace:

Code: Select all
  at Spire.Xls.Core.Spreadsheet.XlsPageSetupBase.ParseRecord(BiffRecordRaw record)    at Spire.Xls.Core.Spreadsheet.XlsPageSetup.ParseRecord(BiffRecordRaw record)    at Spire.Xls.Core.Spreadsheet.XlsPageSetupBase.Parse(IList data, Int32 position)    at Spire.Xls.Core.Spreadsheet.XlsPageSetup..ctor(d0 A_0, Object A_1, ArrayList A_2, Int32 A_3)    at Spire.Xls.PageSetup..ctor(cj A_0, Object A_1, ArrayList A_2, Int32 A_3)    at Spire.Xls.Core.Spreadsheet.XlsWorksheet.ExtractPageSetup(Int32 iStartIndex)    at Spire.Xls.Core.Spreadsheet.XlsWorksheet.ParseData()    at Spire.Xls.Core.Spreadsheet.XlsWorksheetBase.Parse()    at Spire.Xls.Core.Spreadsheet.XlsWorkbook.g()    at Spire.Xls.Core.Spreadsheet.XlsWorkbook.b(gb A_0, ExcelParseOptions A_1, Int32 A_2, Int32 A_3, Hashtable A_4, IDecryptor A_5)    at Spire.Xls.Core.Spreadsheet.XlsWorkbook.a(gb A_0, ExcelParseOptions A_1, String A_2)    at Spire.Xls.Core.Spreadsheet.XlsWorkbook.a(ah A_0, ExcelParseOptions A_1, String A_2)    at Spire.Xls.Core.Spreadsheet.XlsWorkbook..ctor(d0 A_0, Object A_1, String A_2, ExcelParseOptions A_3, Boolean A_4, String A_5)    at Spire.Xls.Core.Spreadsheet.XlsWorkbook..ctor(d0 A_0, Object A_1, String A_2, ExcelParseOptions A_3)    at Spire.Xls.Core.Spreadsheet.XlsWorkbook..ctor(d0 A_0, Object A_1, String A_2)    at gn.a(Object A_0, String A_1)    at cj.a(Object A_0, String A_1)    at cr.b(String A_0)    at Spire.Xls.Workbook.LoadFromFile(String fileName)




Also I don't understand why the .Cells property of a Row is always Nothing. The .Columns property does contain values but that is the weird name for the content of a Cell.

Marcel81
 
Posts: 2
Joined: Fri Mar 21, 2008 4:16 pm

Mon Mar 24, 2008 1:52 pm

Sorry for inconvenience.

Spire.XLS can not support for Excel 2007, It will be supported in next release.
User avatar

Flash
 
Posts: 56
Joined: Thu Jun 29, 2006 2:34 pm

Tue Mar 25, 2008 9:35 am

But it's not an Excel 2007 workbook. It's an Excel97 - 2003 workbook which can even be opened by Excel 97.

Real Excel 2007 workbooks are .XLSX

Marcel81
 
Posts: 2
Joined: Fri Mar 21, 2008 4:16 pm

Fri Mar 28, 2008 10:05 am

Hello,

The bug has been fixed, Please download latest version.
http://www.e-iceblue.com/xls/xlsdownload.htm
User avatar

Flash
 
Posts: 56
Joined: Thu Jun 29, 2006 2:34 pm

Return to Spire.XLS