[2023-2-9 09:32:20] [ERROR] 流程块.task 第4行:模块 Excel.ReadRange 命令出错:读取Excel区域失败,请检查Sheet或需要操作的单元格是否存在。
读取Excel剪切板数据时发生异常。
Specified clipboard format is not available
Dim objExcelWorkBook,H,arr,iRet,hWeb,sRet,bRet,arrSelItem,arrElement,objPoint
objExcelWorkBook = Excel.OpenExcel('''C:\Users\st\Desktop\采购日报.xlsx''',false,"Excel","","")
H=Excel.GetRowsCount(objExcelWorkBook,"Sheet1")
arr=Excel.ReadRange(objExcelWorkBook,"Sheet1","A1:K"&H,true)