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 14, 2021 2:05 pm

Hi,
Following code fails in LoadFromStream method with exception:
"Requested value 'lastHeaderCell' was not found."

Code: Select all
Spire.Xls.Workbook workbook = new Spire.Xls.Workbook();
Stream str = ...
workbook.LoadFromStream(str);


I am using FreeSpire.Office nuget package.
This probably fails because following Excel table styles are not supported in Spire.Xls library:
Excel - Home ribbon menu - Format as table - right click on custom table style in attached file - Modify... - "Last Header Cell" and "Last Total Cell" table elements are not supported in Spire.Xls

Thanks,
Filip
Attachments
1-invoice.zip
(9.39 KiB) Downloaded 258 times

filipfilipfilip
 
Posts: 45
Joined: Mon Jun 14, 2021 10:27 am

Tue Jun 15, 2021 7:43 am

Hello Filip,

Thanks for your inquiry.
Yes, this issue indeed exits in our Free Spire.Office. But our latest commercial version (the latest version is Spire.Office Platinum Version:6.6) has fixed it.

Sorry to tell you that we only upgrade the free version irregularly. Thus, we recommend you try with our latest commercial version. And we are willing to provide a temporary license (one month free) to help you evaluate our commercial version better and remove the warning message. If interested, please contact our sales team (sales@e-iceblue.com) to get it.

If there are any questions, just feel free to contact us.

Sincerely,
Brian
E-iceblue support team
User avatar

Brian.Li
 
Posts: 1271
Joined: Mon Oct 19, 2020 3:04 am

Mon Jun 21, 2021 10:58 am

Hello Filip,

Have you tried our commercial version? Can it meet your needs? Any feedback will be greatly appreciated.

Sincerely,
Brian
E-iceblue support team
User avatar

Brian.Li
 
Posts: 1271
Joined: Mon Oct 19, 2020 3:04 am

Tue Feb 22, 2022 9:45 am

Thank you, it works in commercial version.

filipfilipfilip
 
Posts: 45
Joined: Mon Jun 14, 2021 10:27 am

Tue Feb 22, 2022 9:49 am

Hello,

Thanks for your feedback!

Glad to hear that your issue has been solved.

If you encounter any issues related to our product in the future, just feel free to contact us.

Have a nice day!

Sincerely,
Marcia
E-iceblue support team
User avatar

Marcia.Zhou
 
Posts: 858
Joined: Wed Nov 04, 2020 2:29 am

Return to Spire.XLS