I need to upload excel file to the Queue. but the problem is the file begins from A2:V and the number of rows will be varying. so, if i open the rang from A2:V1000 for example the Bot will upload all the rows even the empty ones. what should i do to use all excel sheet but starting from A2:V, without uploading the empty rows each time.
Use read range workbook activity and give the “A2” as range. The read range workbook activity output is datatable. Check the row count of datatable. If row count was giving correct then you can continue with read range workbook activity.
Hope it helps!!
1 Like
It’s my pleasure… @mohamed.saty2012
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.