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 Sep 09, 2024 1:19 pm

This error has been showing up seemingly randomly but always on the line where I load from an input file. The input file is an .xlsx format as I do input validation to ensure this, wondering if there is any fix or update being worked on, as the only post I saw regarding something similar was back a few years ago and was marked as fixed in version 6 or so.


Input Data: I have tested this with blank sheets, sheets with 100 lines and sheets with 2000 lines, all produce the same error periodically

Code:
Code: Select all
//Create a Workbook object
Workbook workbook = new();

//Load the file stream
workbook.LoadFromFile(inFile);


Using FreeSpire.XLS 14.2.0 installed as a nuget package in visual studio

My environment is Win 11 64bit, EN-GB

My application type is an asp.net core (MVC) web app using .NET 6.0
Attachments
Screenshot 2024-09-09 140400.png
Call Stack and Error
Screenshot 2024-09-09 140400.png (57.66 KiB) Viewed 45 times

C_disposable
 
Posts: 2
Joined: Mon Sep 09, 2024 1:08 pm

Tue Sep 10, 2024 8:02 am

Hello,

Thanks for your inquiry.I tested it in the same environment as you, but as you said, this situation happened by chance, so I did not reproduce your problem. So in order to help us solve your problem more accurately,you can provide us with your original Excel file for investigation.You can upload here or send it to us via email( support@e-iceblue.com ). Thank you in advance.

Sincerely,
Amin
E-iceblue support team
User avatar

Amin.Gan
 
Posts: 277
Joined: Mon Jul 15, 2024 5:40 am

Tue Sep 10, 2024 8:36 am

Hi, As I had stated in my post, I had tried with a blank xlsx document which had thrown the same error.

Also the chance that the error gets thrown seems to be around 2 in 10 approx

But as per your request here is a blank sheet.
Attachments
Book1.zip
(5.25 KiB) Downloaded 171 times

C_disposable
 
Posts: 2
Joined: Mon Sep 09, 2024 1:08 pm

Wed Sep 11, 2024 7:49 am

Hello,

Thank you for your feedback.
I am still unable to reproduce your issue using the document you provided. Are you loading multiple different documents using multi-threading? First, I recommend that you use our latest commercial version for testing (Spire.XLS for .NET :14.9.1) as the commercial version contains more fixes than the free version. If the issue persists after testing with the latest commercial version, please provide us with a project that can reproduce the problem. You can upload here or send it to us via email (support@e-iceblue.com). Thank you in advance.

Sincerely,
Amin
E-iceblue support team
User avatar

Amin.Gan
 
Posts: 277
Joined: Mon Jul 15, 2024 5:40 am

Return to Spire.XLS

cron