How to open csv file

Help Studio
, ,
1

hello all I want to open csv file and perform some operation . how to do it

2

Hi @dhanashree22

We have an Activity called Read Csv from that you can access the Csv file!

Regards

3

Hi @dhanashree22

Please try start process activity to open,

image

Thanks

4

@dhanashree22 are you trying to open the CSV file for UI Automation ? Try to achieve most of the action using UiPath CSV Activities.

https://docs.uipath.com/activities/docs/read-csv-file

If you still want to open, use Start activity and provide file full path.

5

I want t select two column i.e N O and perform duplicate number operation on that… how do it?

6

Hi @dhanashree22

Your Steps would be as follows below.

Use Read Csv activity and get the out as Datatable.

Use Assign Create a new Datatable variable ie

newDt = readDt.DefaultView.ToTable(true,“YourDuplicateColumn1”,“YourDuplicateColumn2”).CopyTodatatable

Use write range or write Csv the new Dt

Regards

Regards