Extraxt from CSV file and write to Excel

excel
csv
activities

#1

Hi,

I am new to UiPath, I need assistance.
I managed to successfully read a csv file. Now I want to take the data that was read from the csv file, apply “text to columns” functionality and write the output to an excel file.

thanks.


#2
  1. Did you search in the forum?

https://forum.uipath.com/search?q=csv%20to%20excel

  1. How are you holding the CSV data that you read? in a datatable? If so use Write Range Property.

  2. to read csv you can use Read CSV/Read Range activities and get the data into a DataTable

  3. to write the datatable into an Excel sheet, use Write Range activity.