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

Help Activities
, ,
1

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

image
image747×286 57.2 KB

thanks Advance.

2

Hi @anon24744774
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: