dim i = "" dim arrayRet = "" dim iRet = "" dim iRet1 = "" dim 源数据 = ""
源数据 = Excel.BindBook("武侠人名.xlsx") iRet = Excel.GetRowsCount(源数据,"Sheet1") i = 0 arrayRet = Excel.ReadRange(源数据,"Sheet1","A1:A" & iRet ) TracePrint(arrayRet) For Each value In arrayRet TracePrint(value) iRet1 = Len(value) TracePrint(iRet1) For Each value1 In value i = i+1