How to read excel by skipping couple of initial line's

Help Studio
, ,
1

how to read excel by skipping couple of initial line’s

image
image1366×768 56.1 KB

2

At read-range you can choose which range to select
image

3

@mwerner but range keeps changing

4

Use Lookup Range to search first line(“Resource requirement - Sales” in your case)
Then you can set range for Read Range

5

@Dongjin_Lee AS i have checked headers are showing up in 3 rows and some 1 row

ex: proposed associate name in 3 rows and Role in 1 row

6

I think you can’t do directly read that datatable as you want.

You have to modify datatable after reading.

7

@Dongjin_Lee how can i modify the datatable