For each row Activity without taking headers as a row

Hi!, I have a for each row activity that takes the rows contained in an excel file, but I need it to take only the rows of data and not the headers so that if the excel has a total of 10 rows an 1 of them is a row of headers it only takes as if there are 9 rows total for the iteration.
Thanks in advance for any suggestions!

Hi @Cruz_Becerril_Alliso

while reading the excel using read range it will consider the first row as header and then while iterating through the datatable, it will consider the rows except the header.

Nived N
Happy Automation

1 Like

@Cruz_Becerril_Alliso - While using the Read Range activity, please check in the check box in properties section, then it will consider has a header. If you unchecked first line item consider has a row item.


Happy Learning :slightly_smiling_face:

1 Like

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