Aspose failed to open excel file

Aspose.Cells Product Family
1

Hi,


I have an excel file saved in excel 2002 SP3 (Mircosoft Excel Workbook).

The file can not be opened by Aspose.cells (5.1.1.0).

Please help. Thanks.

Attached is the excel file.
2

Hi,

The file does not open with the latest version: Aspose.Cells
for .NET v6.0.1.3

However, the same file does not open well in Ms-Excel 2010. It shows error message as displayed in screenshot. So it appears to be a corrupt file.

Screenshot:

3

Hi,


When I opened and saved as the excel file in other computer (MS Excel 2002 SP3). The Aspose.cells able to open the excel file. The file can be opened in MS Excel 2002, 2003 and 2007. Do you have any idea about this? Thanks.
4

Hi,

I found “NullRefereceException” exception while loading/opening the file by Aspose.Cells. The file opens fine into MS Excel 2007 but shows warning error message (in protected view) in MS Excel 2010.


Sample code:

Workbook wb = new Workbook(“e:\test2\Book6.xls”);

I have logged a ticket for the issue with an id: CELLSNET-29511. We will figure it out soon.

Thank you.
5

Hi,


When I opened and saved as the excel file in other computer (MS Excel 2002 SP3). The Aspose.cells able to open the excel file. The file can be opened in MS Excel 2002, 2003 and 2007. Do you have any idea about this? Thanks.
6

Hi,


Yes, as I mentioned, we found the issue and will fix it soon.

thank you.
7

Is the any work around for this issue? I have to solve it asap. Thanks.

8
Hi,

I am afraid there is no workaround for the issue. We are working on the issue and we will try to provide the fixed version within 3 days or so. Once it is fixed, we will provide the fixed version here.

Thank you.


9

Hi Amjad,


Thanks. May I know what is the cause of this issue?
10

Hi,


Well, your issue is due to some non standard record(s) in your template file which Aspose.Cells could not process it fine. We will enhance the product to read/process your file fine even if it has some non standard records in it.

Please spare us some time (approx. 2 days), we will fix your issue soon.

Thank you.
11

Hi,

We have fixed this issue. Please download: Aspose.Cells for .NET v6.0.1.4

12

Hi,


My ASPOSE license is expired, is there any way to test? Thanks.
13

Hi,

You can test it in Evaluation Mode, it is fully functional with no restriction except that it will create an Extra Evaluation worksheet inside the workbook.

14

Hi Amjad,


May I know what is the “non standard record(s)”? Is it the file corrupted or something else? Thanks.
15

Hi,

The issue is cause by Protect record.

The standard record is 0x12 0x00 0x02 0x00 0x00 0x00

But your record is 0x12 0x00 0x00 0x00

16

Hi,


Can I change the non standard record(s) to standard record(s) in Microsoft Excel? Thanks.
17

Hi,

Please re-save the file in Microsoft Excel , it will be fine.

18

Hi,


Thanks for your reply.

I have tried in different PCs, and with different version of excel. (2002, 2003, 2007)

I notice that the excel 2002 of some PCs have this issue, after re-saved, the issue still there. How can I make sure that there is non standard record(s) in the excel file? Thanks.

19

Hi,

We have no solution to check whether there is non standard record(s) now.

20

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

This message was posted using Notification2Forum from Downloads module by aspose.notifier.