How to copy specific columns of a cvs file to an existing excel file with StudioX

Help StudioX
1

Hello everyone, I’ve been struggling with this for a while… I have a tight deadline so I decided to seek help here:

I want to be able to tell StudioX to open a csv file, copy column A… and then paste said column on a existing excel (named Excel1), meaning that column A of Excel1 should cvs’s copied column values.

2

Hii @adriana.echevarria3

Read the csv file and store it in a datatable by using Read CSV activities.
Use for each row in datatable activity to iterate the datatable.
Use write cell activity to write the data in the excel in the preferred first column.

Hope it helps!!

3

Hello @adriana.echevarria3,

  1. Open UiPath StudioX and create a new project.
  2. Use the “Open Application” activity to open Excel1. Select the Excel file and indicate the application/window to open it.
  3. Use the “Read CSV” activity to read the CSV file. Select the CSV file you want to read.
  4. Use the “Copy Data” activity to copy the data from column A of the CSV file. In the “Copy Data” activity, specify the source as “CSVFile1” (or whatever name you provided to the CSV file) and the column as “A” (assuming you want to copy column A).
  5. Switch back to the Excel1 application using the “Switch To” activity. Indicate the application/window to switch to Excel1.
  6. Use the “Paste Data” activity to paste the copied data into Excel1. In the “Paste Data” activity, choose the destination as “Excel1” and specify the cell where you want to paste the data.
  7. Save the changes to Excel1 using the “Save Workbook” activity.
  8. Finally, use the “Close Application” activity to close Excel1.

Hope it helps!!!
Cheers. :slight_smile: