Convert multiple text files with data tables into one Excel file using UiPath

Help Activities
1

Hi All, I am trying to read data from txt file and store it into a datatable and and write it to new excel.

2

Hello @ASHISH_MHASKE

Does the text file have any delimiter (comma, semicolon etc.) to indicate when you would have a new column or value?

If there is a delimiter to work with, then you could use a Read Text File activity and a Generate Data Table activity to convert the String into a Datatable.

Regards
Soren

3

Thanks @SorenB I have created the solution , i have used tab as delimiter, it is working fine. But after that it is giving some issue while merging empty datatable and new datatable which is we generated after reading multiple .txt files .

and at the end when i am trying to write datatable to excel activity it is not giving me expected output

4

TextToExcel.zip (16.3 KB)

This is my solution if you can help me please guide me.

5

@ASHISH_MHASKE

I verified your code, you are getting issues when you are using excel application scope. Tried the same with Workbook actiivty , its working fine.
I have attached the code for you.

image
image702×540 17.5 KB

TextToExcel.zip (44.5 KB)