Re: [PLUG] Password protected .xlsx; cannot save as .ods

[Rich Shepard]

On Sat, 4 May 2024, Michael Ewan wrote:

Opening it in LO Calc shows each sheet is protected.  The author would need
to change that.
Or use this Python script.

#!/usr/bin/env python

import sys
import pandas as pd

sheet = sys.argv[2]
df = pd.read_excel(sys.argv[1], sheet_name=sheet)
df.to_csv(sheet+'.csv')  # or df.to_excel()

Thanks, Michael.

Monday I'll ask the project manager to remove the protection.

Regards,

Rich