petemc89 / craxcel Goto Github PK

when I run the code I get the following error. I've tried to trouble shoot and I believe it has something to do with my file permissions which are read and write as far as I can tell. I'm using a mac.

I'm a novice. I'm running this within the terminal environment in pycharm

A user should be able to pass in a list of filepaths that all then get processed.

The list should take on an easy to use form, such as a .txt with each filepath seperated by a new line. Possibly also allow multiple filepaths to be written directly as command line arguments.

Microsoft Word and Powerpoint can both have their protections unlocked in the same way as Excel and should therefore be added to the application as well.

There should be a base class to wrap up all the common fields and functionality, i.e. "MicrosoftOfficeFile".

I created an excel file with a password, but the unlock is failed.

My expectation when using this utility is that I will be unlocking my original document. Instead of creating a new document in the "unlocked" directory, the default behavior should be to overwrite the original document.

To handle scenarios in which the original document should be maintained, I would also suggest adding some sort of "--preserve" flag to keep the original documents around.

Hi

I would like to open an excel file and disable the worksheet protection as in the picture.

I have downloaded the craXcel.py file but have no clue how to start to unlock the excel via python.
Since all of the worksheet is protected therefore pd.read_excel and openpyxl.load_workbook('NXTS122ND8S10.xlsx') cannot read the excel.

Any help would be appreciated.

Thank you.

NXTS122ND8S10.xlsx

Currently, craXcel is creating "temp" and "unlocked" directories in the current directory of the file being unlocked. Instead, this should use tempfile to transparently create temporary directories and remove them once they are no longer needed.

Book1.xlsx
please look at it!!!! thank you