search

awalker89 / openxlsx

R package for .xlsx file reading and writing.
Other
364 stars 78 forks source link

password protection #213

Open debarros opened 8 years ago

debarros commented 8 years ago

Looking around, I didn't see any code or issues related to accessing password protected files. Is that functionality planned? Or does it already exist and I just couldn't find it?

Thanks, and thanks for all your work on this awesome package.

awalker89 commented 8 years ago

Hi, there's no way to do this currently. I'll keep this issue open but doubt it will happen anytime soon, if at all.

kainhofer commented 6 years ago

@debarros What do you mean with "password-protected files"? Excel has severl levels of password protection. A password that you have to enter before the file can be opened at all means the file is encrypted with that password. That's not available in openxlsx.

However, if you are talking about workbook and worksheet-level editing protection, then you can use openxlsx to open and modify these files without problems. Enforcing the password protection is done at the application level and since openxlsx does not check passwords, it bahaves just like no password is set.

If you want to set worksheet/workbook protection, my PR #413 adds this functionality.