We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Opening an XLS file via Aspose.Cells APIs

Hi,

I get a NullReferenceException when opening a workbook like:
var theWorkbook = new Workbook(filename);

Stacktrace:
at . . ( )
at . .Read( )
at Aspose.Cells.Workbook. (String , LoadOptions )
at Aspose.Cells.Workbook…ctor(String file)

Tested with Aspose Cells .NET 2.0:
- v7.4.0
- v7.7.2
- v8.1.2

See the attached sheet.

Hi Ronald,

Thanks for your posting and using Aspose.Cells.

Actually, your source xls file is corrupt. It does not open fine in MS-Excel 2010. It shows the warning as shown in this screenshot. Therefore Aspose.Cells also throws exception on opening it.

However, we have logged this issue in our database for further investigation. We will look into it and fix this issue if possible. Once, there is some fix or other update for you, we will let you know asap.

This issue has been logged as CELLSNET-42863.

C#


string filePath = @“F:\Shak-Data-RW\Downloads\Sheet+Deelnemers+Online+24-07-2014.xls”;


Workbook workbook = new Workbook(filePath);

Exception:
A first chance exception of type 'System.NullReferenceException' occurred in Aspose.Cells.dll

at ‰..š( )
at ‰..Read( )
at Aspose.Cells.Workbook.Ÿ(String , LoadOptions )
at Aspose.Cells.Workbook..ctor(String file)

Thanks for your quick reply. I have Office 2013 here, and have no problem opening the sheet.

Hi Ronald,

Thanks for your feedback and using Aspose.Cells.

We have logged this information in our database. Hopefully, it will be helpful in fixing this issue. Please spare us some time. Once, there is some fix or other news for you, we will let you know asap.

Hello Shakeel,

Our customer told me he created this sheet with Excel 2007. So it appears to be a valid sheet for Excel 2007 and 2013, but not for Excel 2010.

Ronald

Hi Ronald,

Thanks for your feedback and using Aspose.Cells.

We have logged this information in our database. Please spare us some time. Once, there is some fix or other news for you, we will let you know asap.

Hi,

Please try our latest version/fix: Aspose.Cells for .NET (Download Section)


We have fixed the issue now.

Let us know your feedback.

Thank you.

Thanks a lot, the issue seems to be resolved.
We’ll have to renew our license to use this fix though :wink:

Hi Roland,


Good to know that you are up and running again. In order to renew your subscription, please create a thread in Aspose.Puchase forum for further assistance.

The issues you have found earlier (filed as CELLSNET-42863) have been fixed in this update.


This message was posted using Notification2Forum from Downloads module by Aspose Notifier.