Sheetjs: Read a xlsx file protected with password

Created on 10 Aug 2017 · 7Comments · Source: SheetJS/sheetjs

Hi.

I try to read a xlsx file protected with a password.
I use this syntax :
readFile('myfile.xlsx',{"password":'aaa'})

but I receive this response:
File is password-protected

How can I fix this ?

Thanks

Protection

Source

DaviD-Elbaze

👍7

Most helpful comment

I think that's perfectly understandable, but in that case, the error message returned needs to be clearer, because as it stands it makes it seem like a bug where it's not reading the provided password, rather than a limitation of the Community Edition in conjunction with the file version.

ytilis on 14 Jun 2018

👍4

All 7 comments

@SheetJSDev would be very useful to have this feature implemented. Are there any tentative timelines ?
Understanding your current thought process on how this could be implemented would be appreciated as well.

shivamadhavan on 17 Feb 2018

@SheetJSDev is this feature going to be implemented?

ZackBarnes on 24 May 2018

We're trying to tighten the scope of this project so that we can eventually reach a stable 1.0.0 version. This may be implemented in the open source version at some point, but there are no plans at the moment.

SheetJSDev on 24 May 2018

Why is this feature listed under "Parsing Options" in the documentation if it hasn't been implemented yet? This is very confusing for users looking to use this library for protected files.
https://docs.sheetjs.com/#parsing-options

ytilis on 13 Jun 2018

👍2

There are quite a few formats @ytilis -- the library currently has code for the weak encryption used in older XLS files. For modern XLS files and the XLSX/XLSB format, the password protection schemes are different (those are supported in the Pro encryption package). In the push to 1.0 we're unlikely to add it to the Community version.

SheetJSDev on 13 Jun 2018

ytilis on 14 Jun 2018

👍4

Hello,
is this feature already implemented?
I wish i could be able to read a XLSX file protected by password!
If there is something that could be done to solve this please let me know.

To be more expecific there is a XLSX file that i neet to read, inside this file i have more then one sheet the point is the sheet that i whant to read is no protected is there any whay to ignore the others sheet? I think this way o could avoid the protect password

thks