merge - “工作表”对象没有属性“_merged_cells”
问题描述
在将单元格与 openpyxl 合并时,我一直在阅读与修复 excel 边框问题相关的所有材料。我的问题是我正在尝试从 bucketlist 中实现monkeypatch 提到的解决方案,并在此处的其他帖子中提到,但是在运行它时我不断收到错误消息。
AttributeError:“工作表”对象没有属性“_merged_cells”
谁能指出我正确的方向?
from itertools import product
import types
import openpyxl
from openpyxl import worksheet
from openpyxl.utils import range_boundaries
from openpyxl import Workbook
def patch_worksheet():
"""This monkeypatches Worksheet.merge_cells to remove cell deletion bug
https://bitbucket.org/openpyxl/openpyxl/issues/365/styling-merged-cells-isnt-working
Thank you to Sergey Pikhovkin for the fix
"""
def merge_cells(self, range_string=None, start_row=None, start_column=None, end_row=None, end_column=None):
""" Set merge on a cell range. Range is a cell range (e.g. A1:E1)
This is monkeypatched to remove cell deletion bug
https://bitbucket.org/openpyxl/openpyxl/issues/365/styling-merged-cells-isnt-working
"""
if not range_string and not all((start_row, start_column, end_row, end_column)):
msg = "You have to provide a value either for 'coordinate' or for\
'start_row', 'start_column', 'end_row' *and* 'end_column'"
raise ValueError(msg)
elif not range_string:
range_string = '%s%s:%s%s' % (get_column_letter(start_column),
start_row,
get_column_letter(end_column),
end_row)
elif ":" not in range_string:
if COORD_RE.match(range_string):
return # Single cell, do nothing
raise ValueError("Range must be a cell range (e.g. A1:E1)")
else:
range_string = range_string.replace('$', '')
if range_string not in self._merged_cells:
self._merged_cells.append(range_string)
# The following is removed by this monkeypatch:
# min_col, min_row, max_col, max_row = range_boundaries(range_string)
# rows = range(min_row, max_row+1)
# cols = range(min_col, max_col+1)
# cells = product(rows, cols)
# all but the top-left cell are removed
#for c in islice(cells, 1, None):
#if c in self._cells:
#del self._cells[c]
# Apply monkey patch
m = types.MethodType(merge_cells, None, worksheet.Worksheet)
worksheet.Worksheet.merge_cells = m
wb = Workbook()
ws = wb.create_sheet('Mysheet')
patch_worksheet()
ws.merge_cells('A21:C21')
test_cell = ws['A21']
test_cell.value = 'My comment'
test_cell.border = Border(top=medium, left=medium, right=medium, bottom=medium)
test_cell.font = Font(b=True, color='000000')
test_cell.alignment = Alignment(horizontal='center', vertical='center')
wb.save('test.xlsx')
解决方案
推荐阅读
- r - R中的儿童成长图表
- python - 无法从多处理代理上的类访问属性
- javascript - 如何使用 JavaScript 将日志保存到文本文件
- html - 如何在角度 8 中从一个组件到另一个组件获取选定的选项值
- unit-testing - 模拟在参数化测试 Spock 中不起作用
- sql - 具有连接的每个策略的最新记录数
- java - sikuli性能不够快
- javascript - 使用 react-redux 获取单个文件中的数据
- android - 如何查看 Firebase 电子商务事件的“items”参数的内容
- c# - 如何使用 C# 将 0.1333333333333333333333333333 舍入为 0.133334