Need to generate output file in same file for the day

Help Studio
, ,
1

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

image

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 !!
cheers…

2

Hi @mittal.abhishek ,

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

3

Hi @mittal.abhishek

You can try like this

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

Regards
Sudharsan