Skipping header line

Hi @Pranav_KomandurPK

Please try this steps,

  1. Read the excel and Store in a datatable variable name dtTable.

  2. Use remove datarow activity and remove the first row,

https://docs.uipath.com/activities/docs/remove-data-row

OR

  1. In Assign activity
    dtTable = dtTable.asenumerable.skip(1).copytodatatable

  2. If you want to skip actuall headers you can tick addHeader property in read range.

Thanks

3 Likes