37,719
社区成员
发帖
与我相关
我的任务
分享
from openpyxl import load_workbook
from openpyxl.comments import Comment
xl_file = "d:/test.xlsx"
xl_savefile = "d:/test_save.xlsx"
if __name__ == '__main__':
wb = load_workbook(xl_file)
ws = wb.active
for i in range(1,10):
comment = Comment(u'增加批注{}'.format(i), u'陈年椰子')
ws['A%d'%i].comment = comment
wb.save(xl_savefile)
wb.close()