python 操作excel 添加 批注

[坦桑尼亚奥杜威峡谷能人]

如题，python 操作excel 给每列批量添加 批注 怎么做 ？？

[陈年椰子]

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()