Excel Sheet having two datas

[Palaniyappan (Palaniyappan P)]

Check this out

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.…

How to divide the 2 datatables from one sheet to different sheet

ExcelDemoSearch.xaml (9.0 KB) Sample_file.xlsx (134.9 KB) Try the attached.

How to split data table from excel sheet

[image] This is my input data [image] I want my input data to be written in the word file as shown in above format How can I achieve this? How can I split data tables?

@ajnaraya