Unusual NullReference exception from Spire.XLS.DLL

[dgh8]

Thank you for your response Caroline, but it does seem you haven't read everything else that has been posted in this thread.

I have no problem that your library being unable to open files if Excel can't. It is a fallacy your product works like Excel though; yes you followed the ECMA standard (not Microsoft), but your library is managed code and doesn't have the same internal logic/defaults that Excel sets. An example is that your library quite happily allow duplicate "PRINT_AREA" areas in a document, where Excel complains about them and requires them renamed before it will open.

Your library currently throws manageable exceptions if it is unable to open a file, in this case it throws an exception with the message "Root element is missing"; which can and is handled. It is the second exception, which occurs when the application or thread is terminated, that absolutely kills my application. The fact that I'm unable to handle the second exception means I have to treat any code that uses your library as unstable and not fit to be deployed into my production environment.

I'm also shocked to say the least with your dismissive reply, as your colleages have been hounding me to provide a file before you can offer any sort of help or investigation into this issue. Now that I've provided such a file all the previous posts are dismissed, and a simplisitic reply is given. I am fast approach the point where I need to make a recommendation to my management on what library we should purchase and implement into our systems. At the moment, and increasingly so with the last reply, I'm finding it extremely hard to make a case for Spire.Office.

Is there an alternative support route I should try for a better result?

[Betsy]

Dear dgh8,

Thanks for your detailed information.
Sorry that Caroline didn't make the reply clearly, She just answered the issue for the file( Print.xlsx ) you provided.
About your previous issue, it throws exception:System.NullReferenceException was unhandled. It is different exception from the file you provided throw. So they are two different issues, the file you just provide doesn't help us do an investigation for previous issue. And the information you provided is not enough, and we don't have the file, it is difficult to say what the reason caused this issue. We will try to look into the issue, once there is any update, we will inform you soon.
Sorry for inconvenience caused.

Sincerely,
Betsy
E-iceblue support team.

[karanbodhani]

Hello,

I am getting the same issue.

While I am just loading the excel file.
Workbook book = new Workbook();
book.LoadfromFile(fileName);

It is throwing Execption "The given key was not present in the dictionary", after that my code is crashing and throws an exception

System.NullReferenceException
HResult=0x80004003
Message=Object reference not set to an instance of an object.
Source=Spire.XLS
StackTrace:
at spr3059.1(XlsWorksheet A_0, Dictionary`2 A_1)
at Spire.Xls.Core.Spreadsheet.XlsWorksheet.ParseData(Dictionary`2 dictUpdatedSSTIndexes)
at Spire.Xls.Core.Spreadsheet.XlsWorksheetBase.ParseData()
at Spire.Xls.Core.Spreadsheet.XlsWorksheet.44()
at Spire.Xls.Core.Spreadsheet.XlsWorkbook.ClearAll()
at Spire.Xls.Core.Spreadsheet.XlsWorkbook.DisposeAll()
at Spire.Xls.Core.Spreadsheet.XlsWorkbook.Close(Boolean SaveChanges, String Filename)
at Spire.Xls.Core.Spreadsheet.XlsWorkbook.Close(Boolean saveChanges)
at Spire.Xls.Core.Spreadsheet.XlsWorkbook.Close()
at Spire.Xls.Core.Spreadsheet.XlsWorkbook.Finalize()


I am using Version no - 8.4.8.14040 of Spire.Xls

I have also attached the sample file to reproduce the same.

Thank You

[Lisa.Li]

Hello,

Thank you for contacting.
You were using a quite old version, when testing with the old version, I found that the exception issue indeed exists. But the issue didn't occur when I testing with our latest version (Spire.XLS Pack(Hotfix) Version:9.6.7). Thus, please download the latest version to try it again on your side. If there is still any question, just feel free to write back.

Sincerely,
Lisa
E-iceblue support team

[Lisa.Li]

Hello,

Greetings from E-iceblue.
Did the latest version work for you? Thanks in advance for your feedback and time.

Sincerely,
Lisa
E-iceblue support team