How to create new sheet in excel with current Date

excel
activities

#1

HI,

I want to create a sheet in excel with the current date. I am following this approach.


I am facing error that .range does not exist

Thanks and regrds,
M.Srikanth


#2

Hey @srikanth999

just use this in excel write range sheet name -

"Sheet1_"+DateTime.Now.ToString("dd-MM-yyyy")

and in case of only date then pass

DateTime.Now.ToString("dd-MM-yyyy")

image

image

Regards…!!
Aksh


#3

Thanks man its working good


#4

This way it worked for me, but I wanted you to create a blank guide, can you help me?