以下代码在EXCEL2003可以运行,但在EXCEL2007下不能运行,请高手帮忙看看什么原因:
ds_data.SaveAs(path, Excel5!, false) //保存成为的Excel文件
OLEObject oExcel
OLEObject oBook
OLEobject oSheet
Integer ExcelOK
oExcel = Create OLEObject
oSheet = Create OLEObject
oExcel.ConnectToNewObject( "excel.application" )
oBook = oExcel.Workbooks.Open(path)
oSheet = oBook.Sheets(filename)
oSheet.Cells(1,1).EntireRow.Insert(-4121) //在sheet中插入一行
oSheet.Cells(1,1).Value = 'XXXX'
oSheet.Cells(1,1).EntireRow.Insert(-4121) //在sheet中插入一行
oSheet.Cells(1,1).Value = 'XXXXXX'
oBook.SaveAs(path+'a',43)//运行到这里时候报错
FileDelete(path)
oBook.SaveAs(path,43)
FileDelete(path + 'a')
oBook.Close()
报错图片如下:
请大家看看是什么原因,谢谢了。