🔓
Excel Sheet Unlocker
Remove sheet protection from .xlsx files.
How to use
Run
Run the script/packaged executable from the command line.
Universal unpackaged
py unblock.py [--cli] [--dir]
Powershell:
& "C:\Users\...\unblock.exe" [--cli] [--dir]
Cmd
unblock.exe [--cli] [--dir]
Selecting files
-
If starting without options, you will be presented a multi-file picker. Choose any amount of xlsx files to unblock, select 'Open' and you are done.
-
If starting with
--diroption, you will be presented a directory picker. Select your directory and click 'Select Folder'. Unblocker will then check for and process all viable files in the directory. -
Should you want to run this as
--cliapplication, you will be prompted to enter paths to the target files. In standard mode, you will only be able to point to a single file, in--dirmode, you will be able to supply a directory path.
Options
--dir
Select a directory instead of individual files. All .xlsx files in the directory will be processed.
--cli
Replaces the GUI file/directory picker with cli-input paths. Paths can be specified both explicitly and relative.
Requirements
Written in Python 3.9.7, should work on 3.x. Depends solely on std libraries.
Output
Input-files will be overwritten with unlocked versions.
Limits
Only works on .xlsx files. Older excel formats should be converted using Excel, via 'Save As' -> '.xlsx'
Todo
- More transparent logging
24 May 16, 2022
30 Nov 28, 2022
8 Apr 4, 2022
0 Jul 14, 2022
7 Nov 4, 2022
2 Oct 13, 2022
15 Dec 8, 2022
1 Nov 3, 2021
2 Dec 13, 2021
1 Feb 17, 2022
16 Dec 13, 2021
2 Nov 12, 2021
![Risky [ Zero Tow ]](https://avatars.githubusercontent.com/u/76860656?v=4&s=60)
10 Apr 07, 2022
645 Jan 04, 2023
3 Sep 18, 2022
7 Apr 17, 2022
4 Aug 28, 2022
1 Nov 18, 2021
1 Mar 13, 2022
48 Dec 28, 2022
12 Nov 21, 2022
441 Dec 17, 2022
1 Mar 16, 2022
2 Aug 30, 2022
10 Dec 25, 2022
25 Dec 20, 2021
1 Jan 21, 2022
5 Jan 25, 2022
160 Dec 19, 2022