I have a use case to format each row read from an excel file, then save all the data row to a text file.
I have written a workflow that does the correct formatting of the final text file, BUT I’m only getting the last row data in my text file. See screenshots;
Could someone help with how I can fetch all my data?
excelProblem.zip (17.8 KB)
Use read range workbook activity with Range as A1 and give the sheetname
I also tried that approach, but I had issues reading all the entries under each column.
A few things are not clear from your xaml from zip. But maybe it helps.
When a text file is already present then we add additional data with
I think u r writing line instead of appending line
When u r write line to a text file or overwrites the existing line so only the final one will appear
If u use append line all lines will appear
Try append line or any activity that appends instead of write
Hope this helps
@Palaniyappan that works! . thanks
Use Read Range Workbook activity with sheetname and Page Range as where you want to write give that value…
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.