how to set date and time to excel file

Question

0.00/5 (No votes)

See more:

xlWorkBook.SaveAs("c:\\excelfilename.xls", MyExcel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, MyExcel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);

i want use date\time for replacement of excelfilename like log format.

Posted 15-Aug-11 19:16pm

harishtaware

Add a Solution

2 solutions

Solution 1

Change "c:\\excelfilename.xls" with

C#

"C:\\" + Now.ToString("yyyyMMddHHmmss") + ".xls"

Posted 15-Aug-11 19:19pm

Prerak Patel

Comments

harishtaware 16-Aug-11 1:23am

hey friend Now word showing error:Error 35 the name 'Now' does not exist in the current context

Prerak Patel 16-Aug-11 1:58am

Try System.DateTime.Now.ToString then...

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

harishtaware · Accepted Answer · 2011-08-15T19:51:00

Solution 2

"C:\\" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls"

Posted 15-Aug-11 19:51pm

harishtaware

how to set date and time to excel file

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

how to set date and time to excel file

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us