Help - For Each Row only inserting the last data row fetched from an excel file

Help Activities
, , ,
1

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;

sourceExcelSheet

Final output::
lastdatarow

Could someone help with how I can fetch all my data?

excelProblem.zip (17.8 KB)

2

@Yomi_Oluwadara

Use read range workbook activity with Range as A1 and give the sheetname

Cheers

3

@Anil_G
I also tried that approach, but I had issues reading all the entries under each column.

image
image613×688 16.4 KB

4

@Yomi_Oluwadara

  1. Read range workbook activity is what I suggested above

  2. What you are displaying in message box is row 3 and discharge date is it not getting displayed?

  3. And please remove visible rows only

Cheers

5

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
grafik

1 Like
6

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

Cheers @Yomi_Oluwadara

1 Like
7

@Palaniyappan that works! . thanks
image

8

@Yomi_Oluwadara

9

Use Read Range Workbook activity with sheetname and Page Range as where you want to write give that value…

10

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