I was going trough some of the projects where I use Aspose cells today and upgraded the .dll files, but suddenly there was a problem reading a workbook, it “worked” on 4.0.1.0 but not on 4.0.2.0 returning this exception.
Inner Exception: Aspose.Cells.CellsException
Message: This Excel files contains BIFF7(Excel95 or earlier file format) records.
Code: UnsupportedFeature
TargetSite: Void ၻ(Aspose.Cells.Ss.໓)
Source: Aspose.Cells
StackTrace: at Aspose.Cells.RW.ွ.ၻ(໓ၼ)
at Aspose.Cells.RW.ွ.(Stream Ԏ)
at Aspose.Cells.Workbook.Open(Stream stream)
at ssc.ExcelReader.BreReader.Process() in C:\Arbeid\Visual Studio Projects\ProductionReader\prodbre\BreReader.cs#137
The document is a very heavy/messy document that 4.0.1.0 wasn’t able to calculate the formulas on (not that I needed them I was reading it to collect data).
I went back to using 4.0.1.0. Just wanted to report the change/bug.
Could you please zip and post your Excel file here? It can only be downloaded by Aspose developers. Or you can zip and send it to nanjing@aspose.com. I will check it ASAP.
Generally I think this file is "Microsoft Excel 97-2003 & 5.0/95 Workbook". You can verify it by using MS Excel to open this file and choose "Save As".
To solve this problem, you can save it as "Microsoft Excel Workbook" in MS Excel.
Yes, this file is "Microsoft Excel 97-2003 & 5.0/95 Workbook" format.
In v4.0.1 we just load Excel97 data from it and don't touch Excel95 data. However, this may cause problem. In v4.0.2, Aspose.Cells rejects this kind of files.
I use MS Excel to changed this file to BIFF8 format. Since my posted file can be downloaded by all users, I don't post it here. What's your email address? I will send the changed file to you.