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. I repeat this step for each table. Is there a better way of doing this?


Can you try the following sample? This sample reads datatable from the excel file at once, then split it to each table. (10.8 KB)


Hi @Yoichi , I think this should work thanks! I will try testing this out first on my own data.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.