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 in RPA by Praharsh
518 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 by Anvi
• 10,830 points

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
716 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 in RPA by Abha
• 17,400 points
281 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 in RPA by Abha
• 17,400 points
51 views
0 votes
1 answer

“Read CSV” activity missing in UiPath Studio

Go to your Manage Packages Package and Install the Ui ...READ MORE

answered Apr 23, 2018 in RPA by wrecker
• 3,090 points
390 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,090 points
308 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,090 points
256 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,090 points
902 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
166 views
0 votes
4 answers

Pivot table in excel using UIpath

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

answered Feb 25 in RPA by Anvi
• 10,830 points
721 views
0 votes
1 answer

How to automate creating Directory using UiPath?

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

answered Mar 5 in RPA by Anvi
• 10,830 points
69 views