# -*- coding: utf-8 -*-from xlwings import Workbook, Sheet, Range, Chartimport win32com.client#打開 Excel 檔案xl = win32com.client.Dispatch("Excel.application")#不要讓excel視窗跳出來xl.Visible = Falsewb = xl.Workbooks.Open(r'要寫入Excel的路徑')sheet = wb.ActiveSheet#這就是一個插入註解的動作sheet.Range("A1").AddComment()#讓註解可以被看到sheet.Range("A1").Comment.Visible = True#要放進去的字串commentString ='檔 不能沒有註解'#因為是中文所以編碼一下commentString=(commentString).decode('utf-8')#把字串放入註解裡    sheet.Range("A1").Comment.Text(commentString)#存檔關閉wb.SaveAs(r'excel檔案路徑')xl.DisplayAlerts = Falsewb.Close(True)xl.Quit()