Cell comments not read when using load_workbook
Created originally on Bitbucket by vinod_kandasamy (Vinod Kandasamy)
Here is some test code:
#!python
import openpyxl
wb = openpyxl.Workbook()
wb.active.cell('A1').value = 'hello'
wb.active.cell('A1').comment = openpyxl.comments.Comment('test', 'author')
wb.save('test.xlsx')
wb2 = openpyxl.load_workbook('test.xlsx')
print(wb2.active.cell('A1').value)
print(wb2.active.cell('A1').comment)
Output (with openpyxl 1.8.4):
#!output
hello
None
The writer seems to have worked fine: when the spreadsheet 'test.xlsx' is opened using Excel, the comment is present.