arrayRet2 = Filter([ "进度", "1", "1", "1", "1", "1", "1", "1", "1", "", "", "", "", "", "", "", "", "", "" ],Null,True)
输出是
[
"进度",
"1",
"1",
"1",
"1",
"1",
"1",
"1",
"1"
]
但如果从Excel表读取列,读取同样的数组,执行过滤数组数据,得到的是
[
"进度"
]
附加源代码和Excel表
App.Kill("excel.exe")
objExcelWorkBook = Excel.OpenExcel('''C:\Users\Administrator\Desktop\test.xlsx''',True,"Excel","","")
arrayRet1 = Excel.ReadColumn(objExcelWorkBook,0,[1,3])
TracePrint(arrayRet1)
Excel.CloseExcel(objExcelWorkBook,True)
arrayRet2 = Filter(arrayRet1,Null,True)
TracePrint(arrayRet2)