import xlwings as xw
app = xw.App(visible=False, add_book=False)
wbk = app.books.open('test.xlsx')
sht = wbk.sheets['chartsheet']
title = 'hello world'
sht.charts['图表 1'].api[1].ChartTitle.Text = title
wbk.save()
wbk.close()
app.quit()
import xlwings as xw
app = xw.App(visible=False, add_book=False)
wbk = app.books.open('test.xlsx')
sht = wbk.sheets['chartsheet']
title = 'hello world'
sht.charts['图表 1'].api[1].ChartTitle.Text = title
wbk.save()
wbk.close()
app.quit()