To read multiple tables in excel snd store it in different dt

[Palaniyappan (Palaniyappan P)]

Hi

Welcome to UiPath forum

Have a view on this exact similar scenario with a sample workflow

Reading multiple tables in a single excel sheet

Hi, I have multiple dynamic tables in one excel sheet that have different column headers (fixed for each one). Is there an efficient way for the bot to differentiate and read the different tables? Each table has a table header right above it and then there is a single space between each table. My current logic was to read the entire sheet and loop it till I find the row index of the first table header and the next. Then I can supply the row to another read range activity to read the first table.…

Cheers @Dinesh_ragu