Hi Aspose Team,
I am trying to open an excel worksbook having passowrd & I get the following error "BIFF7 Encryption is not supported"
The password for the attached file is 'test'.
Please let me know.
Thanks,
rohitob
Hi,
Thanks for considering Aspose.
Well, I checked your file. It is encrypted as Weak Encryption (XOR) which may relate to BIFF7 Encryption type. You may check in MS Excel Tools|Options and Click "Security" tab, now click "Advanced" button for confirmation. And mind you Aspose.Cells for java supports BIFF8 and greater file and encryption formats(Excel97-Excel2003).
I think you can try: using MS Excel (e.g., 2003), Save your file with updated encryption type e.g., "Office 97 / 2000 compatible" and click Ok and save the file again. I did this and everything is fine.
Here is my code using updated (related encryption type) file (attached) and it works fine.
Workbook workbook = new Workbook();
workbook.open("e:/Files/test.xls",FileFormatType.EXCEL2003,"test");
Worksheet sheet = workbook.getSheet(0);
sheet.getCells().getCell(10,0).setValue("hello123");
// Saves to file.
workbook.save("e:/Files/test2.xls");
Thank you.
Aspose.Cells now provides support (read/write) for 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.