excelRemoveProtection.sh

excelRemoveProtection(){
    echo "Usage: exelRemoveProtection fichier.xlsx"
    unzip "$1" -d tmp 
    cd tmp/xl/worksheets/
    for i in "$(ls *.xml)" ; do
        sed -i 's/Protection password="[A-Za-z0-9]*"/Protection password=""/' $i
        echo "Hacked $i"
    done
    cd ..
    sed -i 's/Protection workbookPassword="[A-Za-z0-9]*"/Protection workbookPassword=""/' workbook.xml
    cd ..
    zip -r "../$1" *
    cd ..
    rm -r tmp
}