Write value from Datatable to text

Help Something Else
1

Hello All,

I have excel which has 5000+ rows and i need to write into text file.

If use below approach, taking more time to process. How can i achieve this with less time?

This image shows a workflow sequence involving reading a range from an Excel sheet and appending each row to a specified file. (Captioned by AI)
This image shows a workflow sequence involving reading a range from an Excel sheet and appending each row to a specified file. (Captioned by AI)726Ă—796 22.3 KB

2

Hi @NaveenKNave

Use “Read Range” to load the Excel data into a DataTable, then convert it to a string using “Output Data Table”, and finally, write it to a text file using “Write Text File” for faster execution.

If you found helpful mark as a solution. Thanks

3 Likes
3

This image shows a process flow diagram for creating a data table, converting it to text, and writing the text to a file named "logfile.txt". (Captioned by AI)
This image shows a process flow diagram for creating a data table, converting it to text, and writing the text to a file named "logfile.txt". (Captioned by AI)916Ă—416 15 KB

4

Hie Simply Use Read range->output data table → write text .
with using 3 activities you can achieve this.

cheers

5

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