Delete first 9 rows from excel

I want to delete the first 9 rows of this excel, no matter what information exists, in order to start from the “Nombre” header

thank you

when you read excel, you can set read range.
otherwise I recommend skip method.
Dt <- DataTable
Dt = Dt.AsEnumerable.Skip(9).CopyToDataTable <- Assign Activity

Skip Method skip data what you want and return IEnumerable Object.



Especially helpful I had this same issue this morning!

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.