Hey Guys,
I wanted to read an excel sheet which is having multiple tables with different headers. I want to read each table and store it in respective datatable. Can you please help me how to perform this?
1 Like
Hello @Dinesh_rag,
Do you know the ranges of each table? If so, are these ranges always the same? 
Hi @Dinesh_ragu ,
Would you be so kind as to provide us with a sample dataset so that we may be in a better position to assist you?
If the number of tables in the sheet are fixed, and have fixed ranges then you can simply pass in the top left cell from where the table starts as the range:
If the ranges are dynamic, we will require a sample data sheet in order to come up with a logic that will enable you to capture the data you want.
Kind Regards,
Ashwin A.K
1 Like
Please find the sample data, and i might have multiple tables similar to that one. Each table will have only one row excluding the header and the range will not be unique for every time
In this case you should use read range activity with range = A1:D2 and assign it a dt variable.
Then another, read range activity with range = A5:D6 and assign it a dt variable
Hi
Welcome to UiPath forum
Have a view on this exact similar scenario with a sample workflow
Cheers @Dinesh_ragu