python - 使用 python-xlsxwriter 或 bash 打开受密码保护的 ods 文件

Question

我需要一个代码来通过 python3(首选)或 bash 打开电子表格，我给他们密码并让他们阅读。

我尝试使用 python-module "xlswriter"

我用这个方法保护xlsx:

---

import xlsxwriter
workbook = xlsxwriter.Workbook('for-test-password.xlsx')
worksheet = workbook.add_worksheet()
content = (
    ['Gas', 10],
    ['Gasoline',   20],
    ['Potro',  30],
    ['Other',40],
)

row = 0
col = 0
for item, cost in (content):
    worksheet.write(row, col,     item)
    worksheet.write(row, col + 1, cost)
    row += 1
worksheet.protect('Passwd')

或者尝试在 bash 脚本中使用这段代码

LibreOffice -p password -f xlsx for-test-password.xlsx

但这不会返回电子表格中的数据。

Answer 1

I protect xlsx with this method:

worksheet.protect('Passwd')

这不是保护工作簿的密码。它正在保护工作表。 XlsxWriter 不支持密码保护工作簿/xlsx 文件。

来自XlsxWriter docs on protect() :

Note

Worksheet level passwords in Excel offer very weak protection. They do not encrypt your data and are very easy to deactivate. Full workbook encryption is not supported by XlsxWriter since it requires a completely different file format and would take several man months to implement.