python - openpyxl: AttributeError: 'MergedCell' 对象属性 'value' 是只读的

Question

当我尝试在现有 .xlsx 文件中填充单元格，然后将其保存到一个新文件时，我收到消息:

import openpyxl

path = "/home/karol/Dokumenty/wzor.xlsx"
wb_obj = openpyxl.load_workbook(path)
sheet_obj = wb_obj.active
new_protokol = sheet_obj


firma = input("Podaj nazwe: ")
nazwa_pliku = "Protokol odczytu"
filename = nazwa_pliku + firma + ".xlsx"



sheet_obj["C1"] = firma
sheet_obj["D1"] = input()

new_protokol.save(filename=filename)

Traceback (most recent call last):
  File "/home/karol/PycharmProjects/Protokolu/Main.py", line 16, in <module>
    sheet_obj["C1"] = firma
  File "/home/karol/PycharmProjects/Protokolu/venv/lib/python3.7/site-packages/openpyxl/worksheet/worksheet.py", line 309, in __setitem__
    self[key].value = value
AttributeError: 'MergedCell' object attribute 'value' is read-only

Process finished with exit code 1

如何解决？

Answer 1

当您合并单元格时，除了左上角的所有单元格都将从工作​​表中删除。携带合并单元格的边框信息，边界单元合并单元格创建为 MergeCells，其值始终为 'None'

ws.merge_cells('B2:F4')
top_left_cell = ws['B2']
top_left_cell.value = "My Cell"

请尝试这种方法，它对您来说效果很好。