0

I am wondering if there is a way to import data from a xlsx file in protect mode without opening the xlsx file first to change the file into an "editable" state.

At the moment, I have to open every file i downloaded, which is very frustrating and if i do not do this, i will get a NULL file contains nothing when importing data.

please kindly help.

wang892
  • 361
  • 2
  • 5
  • http://stackoverflow.com/questions/13996740/import-password-protected-xlsx-workbook-into-r – Hao Mar 11 '15 at 04:27

1 Answers1

0

Erm, i think i found a solution here, the file i downloaded from the internet is not password protected, it is just in protected mode.

so the answer to this is basically to disable the protected mode in excel. thanks for the answer anyway. @Hao

wang892
  • 361
  • 2
  • 5