execl
SetFormat, FloatFast, 0.2 ;设置小数点位
adOpenStatic := 3
adLockOptimistic := 3
adCmdText := 0x0001
objConnection := ComObjCreate("ADODB.Connection")
objRecordSet := ComObjCreate("ADODB.Recordset")
objConnection.Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Users\清墨\Documents\111.xls; Extended Properties=""Excel 8.0;HDR=Yes;"";")
objRecordset.Open("Select * FROM [Sheet1$]", objConnection, adOpenStatic, adLockOptimistic, adCmdText)
if ( objRecordset.BOF == -1 ) ;查找结果为空
{
GuiControl, Show, 表
Return
}
Gui, Add, ListView, v表 w700 h500, 1|2|3|4
while !objRecordset.EOF
{
get0:=objRecordset.Fields[0].Value
get1:=objRecordset.Fields[1].Value
get2:=objRecordset.Fields[2].Value
get3:=objRecordset.Fields[3].Value
LV_Add("" ,get0,get1,get2,get3)
objRecordset.MoveNext
}
Gui, Show, w700 h500
Return
声明:本站所有文章,如无特殊说明或标注,均为本站原创发布。任何个人或组织,在未征得本站同意时,禁止复制、盗用、采集、发布本站内容到任何网站、书籍等各类媒体平台。如若本站内容侵犯了原著者的合法权益,可联系我们进行处理。

