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…
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
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.
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.