Spire.XLS for .NET is a professional Excel .NET library that can be used to any type of .NET( C#, VB.NET, ASP.NET, .NET Core) application and Java (J2SE and J2EE) application.

Mon Oct 01, 2012 3:29 am

This error occurred when I've tried to open a 2007 XLSX file using method LoadFromFile() "Unexpected token type: tEqual, string value: at position 1. Formula: =SUBTOTAL(9,O6:O11), Position: 2". Error occurs on both versions 6.6.x and 6.8.x. I'm using Windows 7 32bit SP1, .NET 2.0. I've attached this XLSX file here. This error wont happen if I save this file as XLS format to open it. Thank you!

BTW, there is an issue of unmatched color palette between MS Excel and Spire XLS, you can test with this attached file.
(13.46 KiB) Downloaded 429 times

Posts: 5
Joined: Thu May 10, 2012 2:46 am

Mon Oct 01, 2012 12:13 pm


Thanks for your inquiry.
Was your xlsx file generated by MS-Excel? or other tool?
We unpacked your xlsx file with a zip tool, in the file xl\worksheets\sheet1.xml, we found some formulas starting with a "=", for example in cell O5.
hd.PNG (2.89 KiB) Viewed 3757 times

But after resaving your xlsx by MS-Excel, in the beginning of these formulas, there is no the "=".
hd2.PNG (2.63 KiB) Viewed 3757 times

The format of your formual is not supported by our product at present.

Thanks and Regards
Technical Support / Developer,
e-iceblue Support Team
User avatar

Posts: 180
Joined: Mon Nov 08, 2010 3:11 pm

Return to Spire.XLS