Python使用openpyxl插入excel批注，修改批注_openpyxl 可以操作表格寫入批註嗎?

作者：我家小花儿 | 2024-07-31 06:56:37

踩

openpyxl 可以操作表格寫入批註嗎?

一、openpyxl插入批注


from openpyxl import Workbook
from openpyxl.comments import Comment
 
if __name__ == '__main__':
   wb = Workbook()
   ws = wb.active
   comment = Comment('hello comment', 'yunan')
   comment.width = 200
   comment.height = 40
   ws['A1'].comment = comment
   wb.save('test.xlsx')

二、修改批注


from openpyxl import load_workbook
from openpyxl.comments import Comment
 
file = 'C:\yunan\\test.xlsx'
if __name__ == '__main__':
   wb = load_workbook(filename=file)
   ws = wb.active
   comment = Comment('hello world', 'yunan')
   ws['A1'].comment = comment
   wb.save(file)

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/我家小花儿/article/detail/907518