Error Reading Classified Workbook: ECMA-376 Encrypted file missing /EncryptionInfo

[bacalfa]

I get the following error when trying to XLSX.read a workbook after classifying it as "technical data" and saving it with MS Excel in Office 365.

If I change the classification of the file to another type, I'm able to read it with SheetJS. Is there anything I can do to still be able to read it regardless of its classification?

Note: the classification is done by the Azure Information Protection. It somehow labels the file according to the classification selected.

[SheetJSDev]

Can you share the file? Either attach to the github issue or email to hello@sheetjs.com

[bacalfa]

I definitely can't share the actual file. And I'm not sure if I can share any test file that has been classified with AIP. Would it be possible for the SheetJS developers to get it to run your own tests?

https://docs.microsoft.com/en-us/azure/information-protection/what-is-information-protection

https://azure.microsoft.com/en-us/services/information-protection/

[SheetJSDev]

If you are willing to provide the Azure expertise to set up the AIP and explain how to run tests, we could investigate further. Unfortunately we are not Azure experts.

Comments in the MS-OFFCRYPTO spec suggest the library would have to perform network requests to interact with the Azure AD API, which is definitely not something we'd want to integrate. For the same reason, SheetJS does not natively support the Google Sheets API or gsheet files

[thuytrangmt98]

Hi @bacalfa, I have the same error while reading the file. Did you fix it yet?

[SheetJSDev]

@thuytrangmt98 can you share a sample file? If you cannot do it publicly, email hello@sheetjs.com