Read Range: Reading Excel file from Certain Row (nth)

[Sisay_Dinku (Sisay YDG)]

Hi,

I want my process read from the 8th row for every new input file I provide. FYI-I use modern design. Is there anyone who could help with this?

[Anil_G (Anil Gorthi)]

@Sisay_Dinku

modern

Hi @Sisay_Dinku

Please add .Range(“A8”) to it .That should solve it.

cheers

[Sisay_Dinku (Sisay YDG)]

Thanks. But where do I add “A8”? In the case of other read range, I was able to do that. Please let me know where you want me add. Thanks

[Anil_G (Anil Gorthi)]

Hi @Sisay_Dinku

Excel.sheet(“sheetname”).Range(“A8”) this is the format

Cheers

[Sisay_Dinku (Sisay YDG)]

@Anil_G thanks a lot. It works. That’s cool.

[Anil_G (Anil Gorthi)]

@Sisay_Dinku happy automation. Please mark the solution so that others can get help as well

Cheers