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.

Mon Jun 21, 2021 5:28 pm

Hello,
when I try to load a workbook file.xls with LoadFromFile, I get a System.NullReferenceException.
If I save this file.xls as file.xlsx in the same folder, it doesn't happen.
Open mode 97/2003 has no effect on the exception.

What can I do :?:

zahnonen
Attachments
file.zip
the problem-file
(13.89 KiB) Downloaded 422 times

zahnonen
 
Posts: 4
Joined: Mon Jun 21, 2021 4:58 pm

Tue Jun 22, 2021 2:33 am

Hello,

Thank for your inquiry.
I used the latest version of Spire.XLS (Spire.XLS Pack Version: 11.6) to test your file, but did not reproduce your problem. If you were not using the latest version, we recommend you give it a try. If the problem still exists, please provide your test environment such as OS info (E.g. Windows7, 64bit) and region setting (E.g. China, Chinese), your application type such as Console app (.NET Framework 4.5) for our investigation. Thanks in advance.

Sincerely,
Annika
E-iceblue support team
User avatar

Annika.Zhou
 
Posts: 1648
Joined: Wed Apr 07, 2021 2:50 am

Tue Jun 22, 2021 8:09 pm

Hello Annika,

thanks for your effort. I will test it with the latest Free XLS variant and give feedback on this.

With best regards

Zahnonen

zahnonen
 
Posts: 4
Joined: Mon Jun 21, 2021 4:58 pm

Wed Jun 23, 2021 1:33 am

Hello,

You're welcome.
Looking forward to your feedback after testing.

Sincerely,
Annika
E-iceblue support team
User avatar

Annika.Zhou
 
Posts: 1648
Joined: Wed Apr 07, 2021 2:50 am

Fri Jun 25, 2021 2:42 pm

Hello Annika,

unfortunately I get the same result (see pictures). What can the fault be?

Best regards, Zahnonen
Attachments
xls-dll.jpg
xls-dll.jpg (37.63 KiB) Viewed 2348 times
code.message.jpg
code.message.jpg (80.12 KiB) Viewed 2348 times

zahnonen
 
Posts: 4
Joined: Mon Jun 21, 2021 4:58 pm

Fri Jun 25, 2021 3:39 pm

OK, I have not used V11.6, with V11.6 it's fine, thanks!

Best regards, Zahnonen

zahnonen
 
Posts: 4
Joined: Mon Jun 21, 2021 4:58 pm

Mon Jun 28, 2021 1:35 am

Hello,

Thank you for your feedback.
If you have other questions about using Spire.XLS in the future, please feel free to contact us.

Sincerely,
Annika
E-iceblue support team
User avatar

Annika.Zhou
 
Posts: 1648
Joined: Wed Apr 07, 2021 2:50 am

Return to Spire.XLS