The attached XLS failed to convert to PDF, giving the following exception:
Unhandled Exception: Aspose.Cells.CellsException: This Excel files contains BIFF7(Excel95 or earlier file format) records.
at ?.?.?(† ?)
at Aspose.Cells.Workbook.Open(Stream stream, FileFormatType type)
at Aspose.Cells.Workbook.Open(String fileName)
at BankOfAmerica.ECI.MSExcelToPDF.ConvertExcelToPDF(String inName, String outName, Boolean thisDir, Boolean verbose)
Is there a remedy for this?
Does this mean that our customers cannot provide us with XLS files produced from older versions of MS/Excel?
Hi,
Thank you for considering Aspose.
I checked your template file and it is of BIFF7 (Excel 95) format. Aspose.Cells supports BIFF8 or greater formats (Excel 97 - Excel 2007). I think you may try the following steps:
· Open your template .xls file in MS Excel (e.g…,Ms Excel 2003 or 2007).
· Save the file As “Microsoft Office Excel Workbook”.
· Now you can use Aspose.Cells to open/manipulate the file for your requirements.
Thank You & Best Regards,
That is probably not a viable solution for us. Our application is a 7x24 batch process that receives incoming documents from customers in various formats (plain text files, fax TIFF, MS/Word doc, MS/Excel xls, etc.), and converts them all to PDF form. We're considering using Aspose for the doc and xls format conversions.
We have little control over what our customers send us (we have thousands). Any conversion problems encountered would require manual intervention, which we obvious would like to avoid entirely, if at all possible. Ideally, the existing versions of these formats still in widespread use should be converted correctly 100% of the time.
Are there batch (command-line) methods for converting older format (BIFF7) documents to the newer format?
@Loadmaster,
Aspose.Cells now supports (read/write) older MS Excel file formats, including MS Excel 95/5.0, alongside its robust compatibility with newer versions such as MS Excel 2003, 2007, 2010, 2013, 2019, 2021 Workbook, Office 365, and OpenOffice formats. You don’t require a manual workaround anymore. The enhancement ensures greater flexibility and usability across a wide range of Excel versions.
For detailed information on all supported file formats, please refer to the Supported File Formats documentation.
We encourage you to download the latest version of Aspose.Cells using the links below:
Please feel free to reach out to us with any questions or feedback you may have.