Extraxt from CSV file and write to Excel

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.

  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.

1 Like