Error "Unexpected token type" when opening a XLSX file

Technical support for Spire.XLS

Moderators: iceblue support, Flash, Manager

Error "Unexpected token type" when opening a XLSX file

Postby pocketme » 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 268 times
Posts: 5
Joined: Thu May 10, 2012 2:46 am

Re: Error "Unexpected token type" when opening a XLSX file

Postby » 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 3062 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 3062 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

Who is online

Users browsing this forum: No registered users and 1 guest