unprotect.sh

#!/bin/bash
set -e -u

FILE=$1
NAME=$(echo "$FILE" | sed 's/\.[^.]*$//')
EXTENSION=$(echo "$FILE" | sed 's/^.*\.//')

rm -rf $NAME
rm -rf $NAME.zip

cp $FILE $NAME.zip


mkdir $NAME
cd $NAME
unzip ../$NAME.zip
sed -i '' -e 's~<sheetProte[^>]*>~~g' xl/worksheets/*.xml
sed -i '' -e 's~<workbookProte[^>]*>~~g' xl/workbook.xml
zip -r ../${NAME}_unprotected.zip .
cd -
mv ${NAME}_unprotected.zip ${NAME}_u.xlsx

rm -rf $NAME
rm -rf $NAME.zip