有方法 用excel写一个模板的宏,然后将数据写入到excel的指定位置生成图表. Dim waijiaji As Excel.Application Dim x1book As Excel.Workbook Dim x1sheet As Excel.WorksheetSet waijiaji = CreateObject("Excel.Application") Set x1book = waijiaji.Workbooks.Open(App.Path + "\excel\a.xls") Set x1sheet = x1book.Worksheets(1) x1sheet.Cells(2, 1) = "试验" x1sheet.Cells(2, 8) = Text1(4).Text x1sheet.Cells(2, 10) = Text1(5).Text
用excel写一个模板的宏,然后将数据写入到excel的指定位置生成图表.
Dim waijiaji As Excel.Application
Dim x1book As Excel.Workbook
Dim x1sheet As Excel.WorksheetSet waijiaji = CreateObject("Excel.Application")
Set x1book = waijiaji.Workbooks.Open(App.Path + "\excel\a.xls")
Set x1sheet = x1book.Worksheets(1)
x1sheet.Cells(2, 1) = "试验"
x1sheet.Cells(2, 8) = Text1(4).Text
x1sheet.Cells(2, 10) = Text1(5).Text