Hi All,
I’m writing a two different datatbles into a Workbbok. At each time, I want a to create a new workbook with timestamp or the same workbook need to be renamed using timestamp.
Hi All,
I’m writing a two different datatbles into a Workbbok. At each time, I want a to create a new workbook with timestamp or the same workbook need to be renamed using timestamp.
maybe something like:
“myexcel” + now.ToString + “.xlsx”
edit:
this might give you dots and other characters that are not accepted as file name, just replace them with nothing
now.ToString.Replace(“/”,“”).Replace(“:”,“”).Replace(" “,”")
Hi @Abishek,
Here is a shortcut to create the worksheet like bellow that I have attached it.
Sample :NewSheet.zip (1.3 KB)
Note :
To rename the existing excel sheet you can use the below one without losing the data.
Regards
Balamurugan.S