XLSX写入保护：锁定单元格值

Question

我正在尝试将公式锁定在Col J中，因此无法手动编辑，我在文档Enabling Cell protection in Worksheets中没有找到太多关于此的内容。无法关闭（保存）该文件

import xlsxwriter
wb = xlsxwriter.Workbook('output.xlsx')
ws = wb.add_worksheet( 'output' )
ws.write_formula("J3", "=SUM(F3:H3)", 'locked') #locked not string gives NameError
wb.close()

Answer 1

您链接到的示例似乎正是您想要的。您基本上需要打开工作表保护，所有未明确解锁的单元格都将被锁定。例如：

import xlsxwriter

workbook = xlsxwriter.Workbook('protection.xlsx')
worksheet = workbook.add_worksheet()

# Turn worksheet protection on.
worksheet.protect()

worksheet.write_formula('J3', '=SUM(F3:H3)')

workbook.close()