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.
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.
https://forum.uipath.com/search?q=csv%20to%20excel
How are you holding the CSV data that you read? in a datatable? If so use Write Range Property.
to read csv you can use Read CSV/Read Range activities and get the data into a DataTable
to write the datatable into an Excel sheet, use Write Range activity.