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