Is there a way to remove password in a Excel file xls using shell in Linux with known password

Question

Every day, a password-protected Excel file (.xls) arrives on our Linux server; we now manually remove the password from local storage and use it for other reports.

Is it possible to use shell scripts in Linux to automatically remove passwords when the password is known? are any other potential choices?

Answer 1

Dig into the Excel documentation for the exact file format. Perhaps this document will be a starting point (See section 4.19). In any case, I don't think that bash will be the right tool for this task.