dim msg = "需要安装excel"
dim iRet = ""
dim 订单号 = ""
dim arrayRet = ""
dim objRet = ""
dim objExcelWorkBook = ""
try
objExcelWorkBook = Excel.OpenExcel("G:\\实列数据表.xlsx",true)
arrayRet = Excel.ReadRange(objExcelWorkBook,"Sheet1","A1:A388")
TracePrint(arrayRet)
catch
iRet = Dialog.MsgBox(msg,"UiBot","0","1",0)
exit()
end try
为什么我用系统的读取excel区域命令,在调试测试的时候,数据不从第一个输出到最后一个?我读取的是从a1-a388。还有一个疑问,当我使用系统的遍历数组时,如果我数组是一列a1至a388,系统是会执行388次还是一次?如果想想每次读取这列中的一个数据,粘贴到文本框怎么做呢?感谢