Python使用openpyxl插入excel批注，修改批注

最新推荐文章于 2024-08-06 09:43:29 发布

小妖666

最新推荐文章于 2024-08-06 09:43:29 发布

阅读量6.5k

点赞数 4

分类专栏： A-Python 文章标签： Python使用openpyxl插入excel批注，修改批注

本文链接：https://blog.csdn.net/weixin_38883338/article/details/98733734

版权

A-Python 专栏收录该内容

25 篇文章 0 订阅

订阅专栏

一、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)