I have a fairly complex (by my standards) process that extracts Excel files (
.xls) from certain inbound emails and saves them in a directory on my Debian/Squeeze machine.
My next step would have been to use
catdoc) to convert the
.xls files into
.csv, before modifying it using regex and loading it into a database.
However, I just realized that each sheet in the
.xls files is locked, preventing
xls2csv from converting them into
Is there a command/solution to batch unprotect the sheets in
.xls files in a directory? (The idea is to unprotect them in-place, without opening them one at a time.)