xl.Visible = 1
wb = xl.Workbooks.Open('<full path of excel spreadsheet>')
sheet = wb.ActiveSheet
sheet.Range('A1').AddComment()
sheet.Range('A1').Comment.Visible = True
sheet.Range('A1').Comment.Text('Hello World')
wb.SaveAs('<full path of modified spreadsheet>')
wb.Close()
xl.Quit()
How to write excel comments using python?