Yes, UiPath can find the last row of excel and write the new data in next row.
For this, you have to use “Append Range” activity instead of “Write Range” activity.
If you use “Append Range” activity, you won’t get headers.
Feel free to reach us at any time if you have doubts. Thanks.
Thank you, Append range is working. Only thing is it still copies row 1 where the headers are located. Is there an option to exclude row 1?
You can easily remove the headers from the table while reading the data in Read Range.
To do this just uncheck the Add Headers Property in the Read Range Activity as shown below:
You can use “Remove DataRow” activity before “append range” activity.
In “Remove DataRow” activity properties provide the DataTable variable and RowIndex as ‘0’. So it will remove the header and append the rest of the data’s.
Note: Uncheck ‘Add Headers’ in read range(DataTable which you need to append) activity properties.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.