How to write excel data to a Text file

[paul.peter]

How to do following functions in UiPath? Am using Studio 2021.10.3

• Read values from a excel column
• write to the textfile
• Read values from the second excel column
• write to the same text file on the next line.

[AKM_Robinuzzaman (Robin Zaman)]

Hi @paul.peter , Welcome to UiPath community.

Please visit the below link with the same issue. Hope you can find your solution from there.

Thanks.

Writing the whole content of a data table column into a text file

Hi all, I have a datatable with about 200 rows and 60 columns. I’m iterating each one of the columns and looking for a value in all of its rows. To be sure I’m looking to the right place, I wanted to write the whole column that I’m analyzing into a text file, or even to output, so it will help me debug it. Do any of you know how to write the whole column content to a text file or the output? Thanks in advance.

[pravin_calvin (pravin kumar)]

Hi @paul.peter

Welcome to community!

Your Steps would as follows below!

Read range the workbook.

Use For Each row of datatable and pass the readrangeDt

Inside the body of the loop use append line activity!

and pass the row value like Currentrow(“yourColumnname”).toString+Currentrow(“yourColumnname2”).Tostring

Regards