No way to open a XLSX locked by password

Question

No way to open a XLSX locked by password

mariosil opened this issue 7 years ago · 4 comments

Hi, I just wondering if there is a way to open a xlsx spreadsheet which is locked by password.
I even have the password to open that file but I can't find a method in this gem that I could use to open the file.
Something like: SimpleXlsxReader.open(xlsx_filename, password)

There is something to workaround this use case.

Answer 1 · 2017-10-12T00:19:01.000Z

Nope, no explicit support, and I have no idea how passwords work in xlsx files so I couldn’t say whether a workaround is possible.

…

On Wed, Oct 11, 2017 at 4:48 PM Mario ST ***@***.***> wrote: Hi, I just wondering if there is a way to open a xlsx spreadsheet which is locked by password. I even have the password to open that file but I can't find a method in this gem that I could use to open the file. Something like: *SimpleXlsxReader.open(xlsx_filename, password)* There is something to workaround this use case. — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#29>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AABiwuqal9pRm1Yhd1f2m8KbIvwguURnks5srVPigaJpZM4P2RxZ> .

Answer 2 · 2017-10-12T00:21:23.000Z

Uhh, anyway thanks for answer

Answer 3 · 2018-05-16T20:28:05.000Z

Any new thoughts on this?
I have the same issue.

Answer 4 · 2018-07-11T17:10:33.000Z

I don't have a need for this, but I would welcome a contribution to reading password protected files.

Here's an NPM project that appears to have implemented password protected XLSX sheets, you could see how they do it.

Here's the wikipedia page for the feature, although it mostly provides broad background rather than implementation details.

If you could find a command line way to decrypt the files, you could use that first, then this gem. I couldn't find any with a quick googling, but I didn't try very hard.