我想操作xls里图表的范围,如何动态设置
oleobject xlapp,xlsub ,ActiveChart
path_name=‘test.xls’
xlapp.application.workbooks.open(path_name)
xlsub = xlapp.application.activeworkbook.worksheets[1]
ActiveChart = xlsub.ChartObjects("图表 2")
后面不会写了,不知道ActiveChart函数都有啥,哪个是设置取值范围的