How to read multiple table from one excel

Help Activities
, ,
1

In my input excel i have multiple table. I need to read all the data table and need to store in one single data table.

Ex:

image
image1641×150 4.5 KB

2

Hi!

If the position of the tables don’t change you can use Read Range and specify the Range
Activities - Read Range (uipath.com)

How to use Excel Read Range Activity in Modern design? Range & Save to parameters examples? - Help / Studio - UiPath Community Forum

3

Position of table will change. How to handle that scenario.

4

Read the whole excel sheet then and try to manipulate the data.

You could forexample find out the Cell for “Table 1”, then assume that the Cell below it is the start of your table, then try to found “Table 2” and do the same.

You can even let the table number be a variable that you increment in a while loop so that as long as there are “Table {x}” you continue, if you don’t find Table 11, you exit the loop

5

Here table name also dynamic

6

Could you rely on there being an empty column between the tables?

See this thread and adjust for column instead of row
How to split datatable into multiple datatables, using empty row as seperator - Learn / Academic Alliance - UiPath Community Forum

7

@balanirmalkumar.s
image

The image shows a UiPath workflow involving an Excel Application Scope that reads multiple data ranges from different sheets and merges them into a single data table. (Captioned by AI)
The image shows a UiPath workflow involving an Excel Application Scope that reads multiple data ranges from different sheets and merges them into a single data table. (Captioned by AI)393×762 29.9 KB

image
A spreadsheet contains rows of data in columns A and B, with alternating sections of empty rows, and a note in cell A6 instructing to clear empty rows. (Captioned by AI)
A spreadsheet contains rows of data in columns A and B, with alternating sections of empty rows, and a note in cell A6 instructing to clear empty rows. (Captioned by AI)237×590 4.92 KB

Main.xaml (10.8 KB)
Data.xlsx (9.4 KB)

8

Here table rows and columns are dynamic. We cant give range directly.

9

It’s difficult to solve. It have to stable and different column names