I am lopping on a excel files and write a report file but only write the last row is write

Help Activities
,
1

I want to have a reporting file, but the first rows are empty and only the last one is write
I want to have a reporting file, but the first rows are empty and only the last one is write

2

Hi @Soudios

can you share screenshots of the workflow you’ve done?

Regards

3

I open several time the reporting file to write the information, it depends what happened during the process

4

I think you are writing to a cell. Please check the number of the variable that you have given. Increment it if you would like to write in the below cells too. @Soudios

5

Hi @Soudios

In your screenshots, it seems like you have an Assign activity incrementing the variable NbLignesSansCorrep . If this variable holds the count of empty rows or is meant to determine where to write the data, ensure that it is correctly calculated before using it to specify the cell address in the Write Cell activity.

6

i found the solution it was about when i want to create a new repoting file from the template, it was creating a new one for every loop because the activity was inside the loop.
I just moved the activity outside “for each” and now its working

1 Like