Uibot中循环遍历单元格源码

最新推荐文章于 2024-03-25 16:47:28 发布

gf1321111

最新推荐文章于 2024-03-25 16:47:28 发布

阅读量1.6k

点赞数

文章标签： python

本文链接：https://blog.csdn.net/gf1321111/article/details/124078591

版权

Uibot中循环遍历单元格源码

Dim iPID,objExcelWorkBook,arrayRet,iRet,objRet
objExcelWorkBook = Excel.OpenExcel('''C:\Users\哈哈哈\Desktop\测试表.xlsx''',true,"WPS","","")
Excel.ActiveSheet(objExcelWorkBook,"实验")
Excel.WriteCell(objExcelWorkBook,"实验","D1","爱你",false)
For j = 1 To 10 step 1
For i = 1 To 2 step 1

    // TracePrint([j,i])
objRet = Excel.ReadCell(objExcelWorkBook,"实验",[j,i],true)
    TracePrint(objRet)
Next
Next