How to read a single excel sheet as two different data tables

Hi Advance
I have an excel file there two data table same column name but value different how can read data both tables separately.


thanks Advance.

Hi @Rahul369
I am not sure if I have understood it correctly.

The table with the yellow background and the table under the green Step2 are in the same sheet and you want to read them in 2 separate datatables?

If so then do a read range and specify the rows & columns. If the number of rows is dynamic then read everything, make a copy of the DT and filter out in both what you don’t need or don’t need :wink: