Copy Paste data from a .txt file into an Excel file

Help Studio
1

Hello I am new to UiPath,

I would like to execute the following steps :

1- Open a .txt file
2- Select all data in the text file (ctrl + A) and copy it
3- Create an excel document
4- Paste the copied data in the new excel file
5- Run “Text to column” in the Excel file to convert the data into a table, (seperator “;” with repetition)
6- Save the Excel file

Could you please give me the build/ steps in order to make that happen ?
Thank you,
Best regards

2

You’ll be happy to know that you don’t even have to open Excel to do this.

Here is a workflow that does it in 2 activities:

Processusvierge.zip (2,0 Ko)

2 Likes