Hi, any idea how to read specific cell range in all sheets and add them together? Basically just like read range without indicating the sheet number. Thanks
Duplicate of:
In general it could start like this:
retrieve all work sheets
iterate over the found worksheets
read in Excel worksheet
Hi, I got this error.
For Each: Object reference not set to an instance of an object.
Thanks for replying my last comment
ensure
- type argument from for each is set to string
- variables are correct defined and used e.g. WorkSheets is the output of get WorkBook Sheets activity
Hi sorry i have been trying after you sent that message, but still can’t seem to get it, I used these variables
looks like WorkSheet is of wrong datatype
check the variable panel ensure Worksheets is of Datatype: List(Of String)
If i change to this type of variable, I cant use the same variable to output in read range
not clear what is meant by this, but you should be very close to target
-
for each item - WorkSheets (the output of get Workbook Sheets)
let you iterate over all Worksheets -
with read range you read in the excel data of looped worksheet name
-
you can write the datatable directly to another worksheet
OR -
merge the different datatable to a single one
OR
Add it to a list of datatables and process it afterwards
Also do not miss out to go to the UiPath Academy and check out some courses on the essentials of UiPath
Hi, somehow my Datatable is empty still, all the sheets do not get read.
Thanks for helping me thus far, really stuck with this.
ensure that the scope of datatable variable is set to a higher level
kindly note:
current implementation is transporting only last read range result datatable. Please reread the hints for this:
By the scope of DataTable set to a higher you mean B1:B10? As I only want numerical values (all in one column) and the end of my values stop at B6. Still trying to figure out why datatable is empty.
Hi @jing_jing
Seems like your DataTable was refresh everytime because your Build DataTable activity is inside the For Each activity loop. Consider placing the Build DataTable activity before the For Each activity loop.
Hi, any idea how to read all 3 sheets(in my case) into 3 different datatables?
I have tried 3 read ranges but somehow there is some duplication of data (Meaning 2 values copied in Data Table are the same ) , or even getting the same value for all datatables
Ok thanks!This worked for me