SetPointer(HourGlass!)
//利用OLE对象,先将excel另存为tab分隔的文本文件,在导入这个文本文件到数据窗口
//最后删除这个文件
String ls_path,ls_filename,ls_saveasname
Long excelok
Integer li_gfo
li_gfo = GetFileOpenName("选择导出文件",ls_path,ls_filename,"DOC","Excel Files (*.xls),*.xls")
If li_gfo = 0 Then Return//取消操作
If li_gfo = -1 Then
gf_msg('载入失败!',2)
Return
End If
OLEObject ExcelServer
ExcelServer = Create OLEObject
excelok = ExcelServer.ConnectToNewObject( "excel.application" )
If excelok < 0 Then
MessageBox("连接excel失败,检查你的系统是否安装了office",String(excelok))
Return
Else
ExcelServer.Workbooks.OPEN(ls_path)
ls_saveasname = "c:\temp.txt"
ExcelServer.activeworkbook.SaveAs(ls_saveasname,3)
ExcelServer.displayalerts = False
ExcelServer.quit()
ExcelServer.DisconnectObject()
Destroy ExcelServer
dw_1.ImportFile(ls_saveasname)
FileDelete(ls_saveasname)
End If
dw_1.AcceptText()