Unexpected XML tag on Workbook.Lodfromfile

[syedmydeen]

Hello team,

We are facing an issue when reading excel file.
For some file only it is showing this error. However, it is working fine when we manually copy that whole sheet and put into new sheet
I am not sure what was the issue. I have attached the sample file to test it at your end
Kindly test and let me know the status

Note:We have a valid license under [email protected]

Thanks,
Syed

[syedmydeen]

sample file is attached

[Nina.Tang]

Dear Syed,

Thanks for your inuqiry.
I used the latest Spire.XLS (Version: 15.1.3) to load your Excel file, but didn't encounter any exception. I suggest that you first download the latest version to try again, if the issue still occurs, please provide the following information to help us investigate your issue better.
1. Your application type, such as Console app, .NETFramework 4.7.2
2. Your test environment, such as Windows 10, 64bit.

Sincerely,
Nina
E-iceblue support team

[syedmydeen]

Hello,

Thank you for your kind response. I will check with latest hotfix

Thanks,
Syed

[Nina.Tang]

Dear Syed,

Has this version solved your problem?
Any feedback will be highly appreciated.

Sincerely,
Nina
E-iceblue support team

[syedmydeen]

Hi Nina.Tang

Thank you. Yes this hotfix dll fixed the problem. However it is showing evaluation warning in all pages

Thanks,
Syed

[Nina.Tang]

Dear Syed,

Thank you for your confirmation.

Your current license allows you to use versions released prior to June 28, 2023. The latest version compatible with your license is Spire.XLS V13.6.0, which was released on June 14, 2023. I have verified that your file can be successfully loaded using this version. You may proceed with upgrading to this version to resolve the issue.

I would recommend considering renewing your license. By doing so, you will enjory the latest versions with more fixes and new features.

If you have any further questions or need assistance with the upgrade process, please don't hesitate to reach out.

Sincerely,
Nina
E-iceblue support team

[syedmydeen]

Hi Nina.Tang,

Thanks for your kind response. I will check with that version. By the way, where can i get it?

Thanks,
Syed

[Nina.Tang]

Hi Syed,

You can install it from Nuget manager.
https://www.nuget.org/packages/Spire.XLS/13.6.0

Sincerely,
Nina
E-iceblue support team

[syedmydeen]

Hi Nina.Tang

I have downloaded the nuget package. However i could not find any DLL for net2.0(framework 3.5)
Please help me to get that

Thanks,
Syed

[Nina.Tang]

Dear Syed,

Due to the limitation of package size on Nuget, net2.0 dll is not included. The lowest version is net4.0. We suggest that you upgrade your project framework to version 4.0 or higher.

Sincerely,
Nina
E-iceblue support team

[syedmydeen]

Hi Nina

Thanks for your kind information
Unfortunately we cannot change the framework version now
Is this possible to send the net2.0 dll alone to my email id [email protected]?
It would be greatly appreciated

Thanks,
Syed

[Nina.Tang]

Hi,

I have already sent you an email, please check it.

Sincerely,
Nina
E-iceblue support team

[syedmydeen]

Hi Nina

Received the DLL and tested it. It is not showing any error. However as i already stated, it is showing evaluation warning message as "Evaluation Warning : The document was created with Spire.XLS for .NET"

Please let me know how can we remove this?

Thanks,
Syed

[Nina.Tang]

Hi,

From Spire.XLS V13.6.0, we have upgraded the namespace for LicenseProvider, please use the code below to apply your license key.

Code: Select all

//Spire.XLS  version 13.6.0 or above
Spire.Xls.License.LicenseProvider.SetLicenseKey("your license key");

Sincerely,
Nina
E-iceblue support team