Modify CSV file using UiPath

0 votes
How can I update or modify a CSV file using UiPath let's say by adding an additional column to the existing sheet.
Mar 4, 2019 in RPA by Praharsh
1,593 views

1 answer to this question.

0 votes

Hi @Praharsh,

You can add columns to an existing csv file in UiPath using following steps:

1. Open the CSV file using 'Read CSV' activity and save the output into a datatable.

2. Now use 'Add Data Column' to add the additional column into the datatable (output of csv file).

3. Then use 'For Each Row' activity to go through each row of datatable. Here, in this step you can add whatever data you wish to add for each row into that additional column. 

4. Finally, use 'Write CSV' to rewrite or update the existing file by giving the file location of existing file.

answered Mar 4, 2019 by Anvi
• 14,010 points

Hi,

I have a dummy csv file and I want to place the current date and time per row. I followed the above steps, but the output only shows the header "Date sent". 

This is how my for-each activity looks like, see attached.

Related Questions In RPA

+1 vote
1 answer

Looping on URLs from Excel file using UiPath

you have a Excel file with a ...READ MORE

answered Jul 25, 2018 in RPA by Atul
• 5,530 points
1,123 views
0 votes
1 answer

Is there any way to check whether a file exists or not using UiPath?

Hi @Raj, performing this check in UiPath ...READ MORE

answered Mar 20, 2019 in RPA by Abha
• 27,720 points
1,254 views
0 votes
1 answer

Hi Team. How to copy images form pdf file to word using Uipath.

Hey Rudravalambi, to copy images from a ...READ MORE

answered May 17, 2019 in RPA by Abha
• 27,720 points
484 views
0 votes
1 answer

How to scrap only numbers from a pdf file using UiPath studio?

Hi, to scrap only numbers from a ...READ MORE

answered Oct 16, 2019 in RPA by Abha
• 27,720 points
58 views
0 votes
1 answer

Robot Manager in UiPath

the robot.exe file is located in: C:\Users\USER_ACCOUNT\AppData\Local\UiPath\app-17.1.6523\Ui-Robot.exe Hope it ...READ MORE

answered Apr 17, 2018 in RPA by wrecker
• 3,110 points
521 views
0 votes
1 answer

Automation in Uipath

you can use the Database package for connecting  ...READ MORE

answered Apr 17, 2018 in RPA by wrecker
• 3,110 points
434 views
0 votes
1 answer

UiPath vs Workfusion

in WorkFusion, you can create a script ...READ MORE

answered Apr 17, 2018 in RPA by wrecker
• 3,110 points
1,183 views
0 votes
3 answers

Any open source tools for RPA ?

Yes, here is the Free RPA tool ...READ MORE

answered Oct 24, 2018 in RPA by Karthiksiddhu
• 240 points
331 views
0 votes
4 answers

Pivot table in excel using UIpath

You can use Create Pivot Table activity ...READ MORE

answered Feb 25, 2019 in RPA by Anvi
• 14,010 points
1,245 views
0 votes
1 answer

How to automate creating Directory using UiPath?

Hi Misha, to create a directory you ...READ MORE

answered Mar 5, 2019 in RPA by Anvi
• 14,010 points
326 views