XLS with xlrd
>>> from xlrd import *
>>> wb = open_workbook("test.xls")
>>> sheet = wb.sheet_by_index(0)
>>> notes = sheet.cell_note_map
>>> print notes
{(0, 0): <xlrd.sheet.Note object at 0x00000000033FE9E8>}
>>> notes[0,0].text
u'Schmo, Joe:\nHi!'
>>> print(sheet.cell_value(0,0))
<cell value>
https://stackoverflow.com/questions/20331006/how-to-check-if-there-is-a-comment-or-not
XLSX with openpyxl
from openpyxl import Workbook
from openpyxl import load_workbook
wb = load_workbook("test.xlsx")
ws = wb["Sheet1"] # or whatever sheet name
for row in ws.rows:
for cell in row:
print(cell.comment)
https://stackoverflow.com/questions/56010234/is-it-possible-to-read-excel-comments-with-pandas