How do I read some row from the .csv file and store into the variable, I need to write this row into another .xlsx file.?

excel
uiautomation
orchestrator
activities
studio

#1

Hi,

There are 5 columns in that row, and I need to make sure all the column data (without header name) are to be stored in this variable.

I want to write this very same variable (containing the data of row) into an another .xlsx file. Please help .
I am stuck here,
@arivu96, @aksh1yadav, @Roxana_Stratila
Regards,
hacky_wacky


#2

Hi,
Using the “Read range” active to stored the values into a datatable. Can able to verify the data by “For Each Row”. Finally with the help of “Write range”, can able to write into another XL sheet.

Thank you
Balamurugan.S


#3

@balupad14

I know that, but i am not able to locate the .csv file by using “read range” or “read cell”

I am only able to do it using “Read csv”

but I am storing it in a datatable type variable called “data1”, but cant really retrieve it into anothier csv file


#4

Hi,
Set the Delimitator property for “Read CSV” as “Semicolon”.

Thank you
Balamurugan.S


#5

@balupad14,

hey bro can you plz send me some sample workflow plz???
I am not getting it since morning


#6

Here I have attached the sample work flow.

Thank you
Balamurugan.S

File : uipath.zip (2.3 KB)