Skip to content

🔓 Remove Sheet Protection from .xlsx files. Easily.

Notifications You must be signed in to change notification settings

0tii/ExcelSheetUnblocker

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

16 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

🔓 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. Standard Picker

  • If starting with --dir option, 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. Directory Picker

  • Should you want to run this as --cli application, 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 --dir mode, 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
  • Auto-convert xls to xlsx