How to add multiple txt content to excel

I have multiple text files contents need to be converted to excel.
However tried to use Add Data Row activity still doesnt work, only shows the last text file content in excel. Please help. Thanks



In this case, it might be better to use AppendRange instead of WriteRange as the following. Can you try this?


Hello @koolrc812

Do you need to convert the text to a table format and then to add to excel or you need to get each value from text and create a datatable using add datarow acitivity?

If converting string to datatable you can use Text to column activity.


It works!!! Thanks heaps!!!

1 Like

Hi @Rahul_Unnikrishnan , I need to convert the text to excel directly. Yoichi just gave me the solution. Thanks heaps for your time also!!! appreciate!!!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.