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
1,397 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
• 13,960 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,079 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
• 27,200 points
992 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
• 27,200 points
363 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 in RPA by Abha
• 27,200 points
37 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
489 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
403 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,141 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
297 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
• 13,960 points
1,147 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
• 13,960 points
284 views