Get All Data Tables in one Excel sheet

[FINNNNNNNN (Cfm6735)]

Dear Forum,

I have multiple dynamic tables in one Excel sheet, each with different column headers (fixed for each table). These tables are separated by a single blank row, with the table header right above each table.

Currently, my logic involves reading the entire sheet and looping through it to find the row indices of each table header. Then, I use these indices to set the range for another read activity to read each table. I repeat this step for every table.

Is there a more efficient way for the bot to differentiate and read the different tables?

[FINNNNNNNN (Cfm6735)]

TestData.xlsx (10.1 KB)

[Parvathy (PS Parvathy)]

Hi @FINNNNNNNN

Check the below thread. this should help you.

Reading multiple tables in a single excel sheet

Hi, Can you try the following sample? This sample reads datatable from the excel file at once, then split it to each table. [img20210922-2] Sample20210922-1.zip (10.8 KB) Regards,

Regards

[FINNNNNNNN (Cfm6735)]

[lchirathapudi (Pallavi Chirathapudi)]

Hi @FINNNNNNNN

Can you try the below

BlankProcess21.zip (58.8 KB)

Output:

TestData.xlsx (14.6 KB)

Regards,