Free Support Forum - aspose.com

Problem in opening an excel file in BIFF7 format through Aspose

#1

Hi,

I have an excel file which is formatted in BIFF7 format.

When i open that file using Aspose.Cells using workbook.open() method , i get the exception

This Excel files contains BIFF7(Excel95 or earlier file format) records.

Does Aspose support opening or reading excel files formatted in BIFF7. I am using 4.1.1.0 version of Aspose.Cells

Can you please point out where is the actual problem

#2

Hi,

Thanks for considering Aspose.

Well, Aspose.Cells supports BIFF8 or greater formats i.e., (Excel97 - Excel2003). Since your file is of older format (Excel 95 or prior). So you have to convert it to the latest format. The procedure is very simple:

1. Open your template file into MS Excel 97 - 2003.

2. Save the file As "Microsoft Excel Workbook".

Now you may use Aspose.Cells to utilize that file.

Thank you.

#3

Would my BIFF7 format maintained after doing the above operation ?

#4

Hi,

Well, your template file will actually be converted to BIFF8 format but your data, formattings, objects etc. will be retained as previous and there is no physical change to your file contents.

Thank you.

#5

@paragkale,

We recommend you to kindly try upgrading to and use latest version of the product which includes support for older BIFF7 (Excel 95/5.0 - 2003 Workbook) formats with enhancements now:
https://downloads.aspose.com/cells/net

Also, see the document for supported input and output file formats by Aspose.Cells:
https://docs.aspose.com/display/cellsnet/Supported+File+Formats