How to write excel data to a Text file

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.

Hi @paul.peter , Welcome to UiPath community.

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


1 Like

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