8

How to unprotect Excel sheets in Linux (Debian/Squeeze)

view full story
linux-howto

http://unix.stackexchange.com – 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 xls2csv (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 .csv format. 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 (HowTos)