How to add multiple txt content to excel

[koolrc812 (RC)]

Hi
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

[Yoichi]

Hi,

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

Regards,

[Rahul_Unnikrishnan]

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.

Thanks

[koolrc812 (RC)]

It works!!! Thanks heaps!!!

[koolrc812 (RC)]

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!!!