openpyxl写excel批注
from openpyxl import Workbook
from openpyxl.comments import Comment
if __name__ == '__main__':
wb = Workbook()
ws = wb.active
comment = Comment('hello comment', 'wyang')
ws['A1'].comment = comment
wb.save('test.xlsx')
openpyxl修改批注框大小
- openpyxl默认的批注框大小为:
width = '108pt'
height = '59.25pt'
改变此大小,需要修改openpyxl中源码,文件路径如下:
windows路径
%PYTHON_HOME%\Lib\site-packages\openpyxl\comments\shape_writer.py
Linux路径
%PYTHON_HOME%/lib/python3.6/site-packages/openpyxl/comments/shape_writer.py
找到_shape_factory()函数,修改第一行代码中.format()中的height和width即可:
style = ("position:absolute; margin-left:59.25pt;"
"margin-top:1.5pt;width:{width};height:{height};"
"z-index:1;visibility:hidden").format(height = "59.25pt",
width = "108pt")