can't open xlsx files with password about xlsx-populate

[zurmokeeper]

@GX158 Has this problem been solved? I have this problem now, I remember around 2022-July, I tried to be able to parse the encrypted excel, I don't know why it suddenly doesn't work now, I am using wps to create the excel file with password encryption？

[zurmokeeper]

@GX158 I tried again, office excel new with password can be decrypted, wps can not. If you use wps to open the new excel file with password created by office excel and then save it, then use xlsx-populate also can not decrypt it, it should be wps to save some content format changes, resulting in xlsx-populate also can not be decrypted

[zurmokeeper]

@GX158 You can try @zurmokeeper/exceljs https://www.npmjs.com/package/@zurmokeeper/exceljs

// read from a file, decrypt excel files encrypted with password
const workbook = new Excel.Workbook();
await workbook.xlsx.readFile(filename, {password:'123456'});
// ... use workbook

xlsx-populate only supports ecma376 agile encrytion, not ecma376 standard encrytion, this library supports both encryption methods