After reading whole excel file i want to work from where my data start

I have readed the excel file but i want to work on it from middle of the file rest above data is of no use.So how do i start working from that point.I cant give hard coded value in read range activity.It should be dynamic .like from this point i need to start processing.

Please help

@Tabbu

share your sample input file, so if it’s empty at the top rows then you can check number of rows empty and after that you can mention your range

Hope this may help you

Thanks

1 Like

Hi @Tabbu

We can also try with the below expression!

DT.Asenumerable.skip(the rows you need to skip as Integer).CopytoDatatable

Regards