Hi guys
I have just started learning R, and am following whatever video tutorial I can get my hands on online. I am stuck at this point whereby I am trying to execute read.xlsx and I cannot load / install xlsx. Please help.
I'm generating an xlsx file using Openpyxl. And i'd like to protect the workbook itself using a password that I have as a variable in the same script. This can be set manually using File > Passwords.. and setting "Password to open" in Excel itself.
I can't seem to find the exact examples but somewhere I read that xlsx files were basically zip archives, and while it seemed true when I ran commands like unzip -t and 7z x it seems that adding a password using utilities like 7z or zipcloak completely breaks the file when it's put back together.
Excel cannot open the file 'sample.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.
A file with the .xlsx file extension is a Microsoft Excel Open XML Spreadsheet (XLSX) file created by Microsoft Excel. You can also open this format in other spreadsheet apps, such as Apple Numbers, Google Docs, and OpenOffice. They are stored as a compressed Zip file, which contains a bunch of other files used to open the document.
The data sets are available in the Microsoft Excel (.xlsx) file format and organized by the federal fiscal year (October 1 through September 30). Please refer to the Program Record Layout documents provided for each dataset, which lists each field title and respective field description.
 7a63b62549