Still part of my project, I have a CSV file that contains names and email addresses. After an email is sent, I want UiPath of place a timestamp across the first line to confirm delivery, then iterates until it completes the list.
I’m not sure if I just use append or add data row/column. Your suggestion/s is/are appreciated.
When you are iterating through the data table itself you can use add column activity with either current data time (dateTime.Now or even Now should work) or with a custom date time that you require to add it against a particular row.
If the iteration is already done and you have a csv file and you want to add it, then you can read range and import data into data table add column follow the above steps and write range again.
To clarify my case, the program I have reads through the CSV, creates the report, then send it by email.
What I want to achieve is after sending the email, it gets the system time, then updates the csv file under “Time sent” column, and proceeds with the next entry, until it completes the entire list.
Adding to mukesh, there was no specific cells for CSV, as it is delimiter based, so you have to do any operation in Datatable and produce CSV / Excel file