How to add today date with an excel file name created dynamically using c#

Question

0.00/5 (No votes)

See more:

In the following code I would like to add today's date with 'clientstatement.xls'. I want this .xls to be saved as 'clientstatement08022014.xls'. The date format can differ. In my code I have assigned date to a variable v_todaydt.

C#

v_todaydate = (DateTime.Today);
           string v_todaydt = v_todaydate.Date.ToString("dd/MM/yyyy");
           ExcelApp3.ActiveWorkbook.SaveCopyAs("C:\\Users\\RAJENDRAN\\Desktop\\clientstatement.xls");
           ExcelApp3.ActiveWorkbook.Saved = true;

Posted 7-Feb-14 17:11pm

S.Rajendran from Coimbatore

Add a Solution

3 solutions

Solution 1

C#

ExcelApp3.ActiveWorkbook.SaveCopyAs("C:\\Users\\RAJENDRAN\\Desktop\\clientstatement"+DateTime.Now.ToShortDateString()+".xls");
          ExcelApp3.ActiveWorkbook.Saved = true;

use the below istead of that :

C#

Response.ClearContent();
       Response.Buffer = true;
       Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "clientstatement"+DateTime.Now.ToShortDateString()+".xls"));
       Response.ContentType = "application/ms-excel";
       StringWriter sw = new StringWriter();
       HtmlTextWriter htw = new HtmlTextWriter(sw);

       GridView1.AllowPaging = false;
       btnview_Click(this, null);
       GridView1.DataBind();
       GridView1.RenderControl(htw);
       Response.Write(sw.ToString());
       Response.End();

Posted 7-Feb-14 17:57pm

King Fisher

Updated 7-Feb-14 18:43pm

v2

Comments

S.Rajendran from Coimbatore 8-Feb-14 0:29am

I altered accordingly but it throws an exception for this new file:
Microsoft Office Excel cannot access the file 'C:\Users\RAJENDRAN\Desktop\clientstatement2/8/2014.xls'. There are several possible reasons:

• The file name or path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a currently open workbook.

King Fisher 8-Feb-14 0:42am

use this istead of that code :
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "clientstatement"+DateTime.Now.ToShortDateString()+".xls"));
Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);

GridView1.AllowPaging = false;
btnview_Click(this, null);
GridView1.DataBind();
GridView1.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();

Solution 3

Hello World !

I'm new here and I'm so much interested on anything as per skills learning and training with to gained more experiences and work with experts to becomes expert in due times frame.

Thanks for your co-operation

Posted 28-May-22 1:24am

Member 15653559

Updated 28-May-22 2:40am

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Karthik_Mahalingam · Accepted Answer · 2014-02-07T19:23:00

Solution 2

Try this

C#

string filename = "clientstatement" + DateTime.Now.ToString("ddMMyyyy") + ".xls";
ExcelApp3.ActiveWorkbook.SaveCopyAs("C:\\Users\\RAJENDRAN\\Desktop\\" + filename);
ExcelApp3.ActiveWorkbook.Saved = true;

Posted 7-Feb-14 19:23pm

Karthik_Mahalingam

Comments

S.Rajendran from Coimbatore 8-Feb-14 2:31am

Thanks.It worked.

Karthik_Mahalingam 8-Feb-14 3:52am

Welcome Rajendran Thambi:)