Skipping header line

How do I skip the header line (row 1) and look for data starting from row 2 in an excel sheet using UIPath Studio

Thank You!

Set range as β€œA2”

1 Like

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

@Pranav_KomandurPK,

Please follow @prasath_S’s answer, we always uncheck AddHeaders property of Read Range activity when we do not want heardes in datatable.

most imp is that, when you write same datatable using Write Range activity, again uncheck AddHeaders property of Write Range activity, it’s by default uncheck.

1 Like

@Pranav_KomandurPK

Did you issue get resolved?

1 Like

Yup thank you!

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