arrayRet = Excel.ReadRange(objExcelWorkBook,"Sheet1","U2:U29")
空数组 = []
需过滤数组 = arrayRet
过滤数组(空数组,需过滤数组)
Function 过滤数组(空数组,需过滤数组)
iRet = UBound(需过滤数组)
For i = 0 To iRet step 1
If 需过滤数组[i]<>""
arrRet = push(空数组,需过滤数组[i])
Else
End If
Next
TracePrint(arrRet)
End Function
————————————————————————————
[21:47:44]工单查询.task 第18行:名字 空数组 没有找到,已自动定义为变量
[21:47:44]工单查询.task 第19行:名字 需过滤数组 没有找到,已自动定义为变量
[21:47:44]工作路径已切换到 C:\Users\linlifeng\Documents\UiBot\Projects\工单统计提醒\
[21:47:44]流程 工单查询.task 开始运行
[21:47:45]工单查询.task 第12行:15
[21:48:05]工单查询.task 第29行:[
[ "" ],
[ 2.0 ],
[ "" ],
[ "" ],
[ 5.0 ],
[ 6.0 ],
[ 7.0 ],
[ "" ],
[ "" ],
[ 10.0 ],
[ 11.0 ],
[ 12.0 ],
[ 13.0 ],
[ 14.0 ],
[ 15.0 ],
[ 16.0 ],
[ 17.0 ],
[ "" ],
[ 19.0 ],
[ 20.0 ],
[ "" ],
[ "" ],
[ "" ],
[ "" ],
[ 25.0 ],
[ "" ],
[ "" ],
[ 28.0 ]
]
[21:48:05]工单查询.task 运行已结束
求助:还是有空值