OLEObject ExcelServer
Integer ExcelOk
string ls_pathname
ls_pathname = "e:\gzdr\book1.xlsx"
IF FileExists(ls_pathname)=FALSE then
MessageBox("msg","File is not found")
return
end if
ExcelServer = CREATE OLEObject
ExcelOK = ExcelServer.ConnectToNewObject("excel.application")
ExcelServer.Workbooks.Open(ls_pathname)
//ExcelServer.ActiveWorkBook.Sheets("Sheet1").Select
//ExcelServer.Application.Visible = TRUE
//ExcelServer.ActiveWorkBook.Close()
ExcelServer.Quit
每次都是第8行报错
ExcelServer.Workbooks.Open(ls_pathname)
,但实际上是打开文件的
![](https://img.laitimes.com/img/__Qf2AjLwojIjJCLyojI0JCLiAzNfRHLGZkRGZkRfJ3bs92YsYTMfVmepNHL90TUOlXSU9EMW5WWwp0MMBjVtJWd0ckW65UbM5WOHJWa5kHT20ESjBjUIF2X0hXZ0xCMx81dvRWYoNHLrdEZwZ1Rh5WNXp1bwNjW1ZUba9VZwlHdssmch1mclRXY39CXldWYtlWPzNXZj9mcw1ycz9WL49zZuBnL4QTNzIjMxATM0AzMwkTMwIzLc52YucWbp5GZzNmLn9Gbi1yZtl2Lc9CX6MHc0RHaiojIsJye.png)
后来发现,需要让EXCEL应用显示出来,就不会报错了,也不知道为啥原因,所以只有显示后马上最小化
ExcelServer.Visible = TRUE
ExcelServer.WindowState = -4140 //最小化