How to create new excel file every day uniquely

Hi Everyone,

Everyday i need to do datascarping and store in excel file but everyday i will be getting new data so my problem is i need to create a new excel file by using automation and store the scrapped data inside that but these file should unique.

Can any one help me on this please,

Thanks in advance…

@chaithanya_kumar_M

Use Write Range activity

Inside the fileName, you can make as “Pathof the folder” + Today.ToString(“MMddyyyy”)+".xlsx"

If you are running daily above will works will create the xlsx file

If you are running multiple times in a day then use as below

“Pathof the folder” + Today.ToString(“MMddyyyy hhmmss”)+".xlsx"

will will add Date as well as time with seconds

Thanks

1 Like

Hi @chaithanya_kumar_M

Use write range activity and in file path give as “Yourpath\Filename_Prefix” + now.tostring(“ddMMyyyy hhmm”) + “.xlsx” it will craete a new file with creent datetime.

2 Likes

Hi Prasath_S,

It worked for me thanks.

1 Like

Happy to hear @chaithanya_kumar_M mark it as solution if it helps…thanks

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