StackOverflowException when instantiating a new xls.woorkboo

[marcpelchat]

When I run the following code, I get a Stackoverflow error.

ExcelPriceList = new Spire.Xls.Workbook();

with the code: Spire.Xls.Workbook ExcelPriceList;
run a few lines above.

I am using c#, in Visual Studio Community 2019 v. 16.11.19. System is running Windows 10 with lastest updates.

I have just updated spire DLL's to lastest (8.1.1) version using NUGet manager in VS.

The actual error text is:
Process is terminated due to StackOverflowException.
An unhandled exception of type 'System.StackOverflowException' occurred in Spire.XLS.dll

The program '[15164] GAPTrack.exe' has exited with code -1 (0xffffffff).

can anyone helpout here..?

[Triste.Dai]

Hi,

Thank you for bringing the issue to our attention.

I have conducted testing using both the version you mentioned and our latest Office version 8.8.0. However, I did not encounter any exceptions while instantiating the Workbook object. Generally, such problems should not occur during the instantiation of a Workbook object.

To address this issue, we recommend that you consider the following steps:

1. Upgrade your Office product to the latest version available.
2. If upgrading does not resolve the issue, try removing all relevant DLL files associated with our product from your project and then re-import them. This can help ensure that the libraries are properly integrated and configured within your environment.

If the problem persists after following these steps, please provide us with your project files for further investigation. Sharing the project will assist us in reproducing the problem and offering a more targeted solution. You can send it to us via email (support@e-iceblue.com) or attach it here. Thank you for your cooperation.

Best regards,
Triste
E-iceblue support team

[marcpelchat]

I have uninstalled all bits of Spire.Office, and removed the references via NuGet in VisualStudio. I then erased all the files, on my computer that were part of SprireOffice. I then upgraded to the lastest version of Spire.Office by including it in my project through NuGet.

I still have the problem, but I can report a little more detail now.

The issue is the same regardless of the version. More interestingly, is that I can get the code to not generate a Stack Overflow on object creation, but the next line generates the error.

If I instantiate the object into a temp variable on form_load, the 'real' object instatiation then works ok, but crashes when I try to load an Excel file. If I load the excel file into my temp variable, then when I load it for real, it works, but then stackoverflow when I try to read a cell.

I could ship you the project, but It requires access to database information in MSSQL to operate...

[Triste.Dai]

Hi,

Thanks for your feedback.
Could you please share us with your project and detailed description? This can help us better understand and reproduce your issue, so that we can work out a solution for you. You can send them to us via email (support@e-iceblue.com) or attach them here. Thanks for your assistance in advance.

Best regards,
Triste
E-iceblue support team