How to copy the data from text file into each row of excel

Help
, ,
1

How to copy the data from text file into each row of excel

2

@Rachna

Welcome to the uipath community.

  1. Use Read Text File activity to read the data from text file and it will output as string.

  2. And then use Generate DataTable activity and provide delimiter based on your data in the string and will give you output as DataTable.

  3. Finally use Write Range activity to write into Excel file.

3

@Rachna,

Welcome to our UiPath Community!.

Check this xaml, I did it for a different scenario, but it will help you to understand how to write an excel from text file.

TextToExcel.xaml (13.2 KB)

4

Thank you .Will try this.

1 Like