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


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


1 Like

Hi @Tabbu

We can also try with the below expression!

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