Read excel from a dynamic header row number

[Babjee Vangipurapu]

Hi All,

How to read Excel data from a different header row. For Instance my header row is on 20th row I need to start reading the data from 20th row with 2oth row as header. If header starts from 17th row I need to read data from 17th row with 17th row as header.

 

[Sachin_Kharmale]

Hi @Babjee Vangipurapu ,
If your header values are fixed then you can check row with get cell value and then you will get the cell reference.
for example-
your header contains Local Price and its contains in D column then you can iterate D column by read cell value excel VBO.
once you get Local Price value in read cell value then you will get cell reference. then start reading values from reference number like D13 means you need to start with row 13.

I hope it will help you.