How to get bot processed output report as single report if bot started to process day before and same single bot complete today

Hi All,

Currently bot generating separate output report based on the same single bot running days (e.g) If bot start from today & complete tomorrow based on the volume. It is generating the final output report for today &tomorrow date separately.

I need to get the output in same excel if bots running in multiple days also.

Note: This is not Multibot. Single bot only based on the volume taking one more days to complete. But generate separate output.

Can anyone please suggest the loggic.
Thanks !!

@jamuna_T,

In Init state add a output report file name which will be set when you start the bot for example today, even the bot runs overnight, the report name and file path as set in Init state, it will be same for next day as well.

1 Like

Hi @jamuna_T

I think you should use a single fixed file path and append data instead of overwriting. use “Append Range” activity or dynamically calculate the next empty row with “Read Range” + row count, then write new data starting from there. This keeps all results in one sheet regardless of runtime duration.

Happy Automation

1 Like

Hi @ashokkarale
Thanks for the reply, Need to set the file path in excel application scope . Please let me with activities.

@jamuna_T,

Just add the report path to Config dictionary in Init state like this

And wherever you are updating the report, just use this report path like this:

1 Like

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