Automatic saving of Excel files?

Help Activities
1

Hi,

I am a bit confused how automatic saving is meant to work.
I am using UiPath.Excel.Activities 2.23.5.

What I am trying to do is to iterate through a range with For Each Excel Row, read values, process them in another application and then add multiple values in each row.

To save time I do not want to save the Excel file after each change but after each row (to be safe not to loose data when the process crashes).

The UiPath documentation says:
Activities - For Each Excel Row

  • Save after each row - If selected, the Excel file is saved during project execution after each row in the iteration is processed. If not selected, the file is saved only after all the rows in the iteration are processed.

I thought, this is exactly what I want to do, but it seems this does not work.

In the Use Excel File Activity I have set “Save changes” to off, because the Documentation says:
Activities - Use Excel File

  • Save changes - Select this option if you want to save the file after each Excel activity that makes a change to its content. Use the Save Excel File activity if this option is disabled.

As far as I understand, the two documentations do not fit together:
If I activate “Save changes” in the Use Excel File Activity the changes are saved after each change as stated in the documentation and if I deactivate it, the changes are not saved at all.
Activating the “Save after each row” setting in the For Each Excel Row Activity does not seem to work. I am not sure what deactivating it would do. I think, depending on the setting in Use Excel File it would save immediately after each change or would not save at all, but not only after all changes.

Did I miss something? Is there another setting that I set wrong?

For now I use Save Excel File after each iteration.

By the way: Does using For Each Excel Row makes sense at all?
It seem slower than reading all rows in a Data Table once and processing them in memory.
The only advantage I see is that writing back values in single Excel cells is easier with For Each Excel Row.

Kind regards,
Oliver

2

@oliver.klink

Ideally when you uncheck the save in use excel it is mandate to use save excel file activity for the changes to be saved

Cheers

3

Hi Anil,
if I have to use the activity Save Excel File to explicitly save at some point in my process, what is the setting to save after each row iteration in For Each Excel Row for?

Is this function buggy or do we have a misunderstanding about the function?

Kind regards
Oliver

4

@oliver.klink

this is the way to do it for each row

also using save excel file at the end with save in for each also might work…never tried this though

cheers