Need to generate output file in same file for the day

I am working one of the use case where eventually generating output excel sheet in below format :


but here the ask is , if the bot run again for next files then it should add data in the same output file which i am creating date-wise similarly for next day as well.

Any suggestion or comments.
Thanks in advance !!

Hi @mittal.abhishek ,

Maybe you could use Append Range Activity if the File is already present.

Hi @mittal.abhishek

You can try like this

  • Use this condition in if
    File.Exists(“file path “)
    • True : Append range
    • Write range