Excel Automation, read range with skip function?

[vaibhav_manav]

I have excel file, in which i have dynamic data row, and i want to skip first seven row and read all data from eight row to end. But i dont know the end of data row. How can I read that excel range after skip those 7 rows?

[Nishant_Banka1 (Nishant Banka)]

Hi @vaibhav_manav,
You can specify in your Read Range activity, where to start reading the Excel from.
Since you want to read the data from the 8th row, you can start reading the document from A8 and not specify the end. The Read Range activity will automatically read till then end and assign it to a DataTable variable

Let me know if this helps,

Thanks,
Nishant