Error :- BIFF7 Encryption is not supported

Aspose.Cells Product Family
1

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

2
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.