Can I Save Excel File In My Local Folder Automatically (Without Asking Any Save Popup) In C# Asp.Net ?

Question

0.00/5 (No votes)

See more:

, +

Can i save Excel file in my local folder automatically (Without asking any save popup) in c# asp.net ?
Am using below code to create and export excel in my project,

C#

public static void ExportToExcel(DataTable dt, string filename)
      {
          HttpResponse response = HttpContext.Current.Response;
          response.Clear();
          response.Charset = "";
          response.ContentType = "application/download";
          response.AddHeader("Content-Disposition", "attachment;filename=\"" + filename + ".xls\"");
          response.ContentEncoding = Encoding.Unicode;
          response.BinaryWrite(Encoding.Unicode.GetPreamble());

          using (StringWriter sw = new StringWriter())
          {
              using (HtmlTextWriter htw = new HtmlTextWriter(sw))
              {
                  DataGrid dg = new DataGrid();
                  dg.DataSource = dt;
                  dg.HeaderStyle.Font.Bold = true;
                  dg.DataBind();
                  foreach (DataGridItem item in dg.Items)
                  {
                      item.Cells[0].Style.Add(HtmlTextWriterStyle.TextAlign, "left");
                  }
                  dg.RenderControl(htw);
                  response.Write(sw.ToString());
                  HttpContext.Current.Response.Flush();
                  HttpContext.Current.Response.SuppressContent = true;
                  HttpContext.Current.ApplicationInstance.CompleteRequest();

              }
          }
      }

This is wroking,but this code will ask for open or save the excel file. I do not want any popup asking save\open. I want code to save this excel in a path given programatically.

How can i do this ?

Posted 16-Oct-14 20:27pm

Am Gayathri

Updated 16-Oct-14 21:31pm

Pikoh

v2

Add a Solution

2 solutions

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)

Praneet Nadkar · Accepted Answer · 2014-10-16T20:52:00

Hi Kavitha,

In my opinion, yes you can do this.
Just change your function to this:

C#

public static void ExportToExcel(DataTable dt, string filename)
{
    StreamWriter wr = new StreamWriter(@"D:\\" + filename + ".xls");
    try
    {
        for (int i = 0; i < dt.Columns.Count; i++)
        {
            wr.Write(dt.Columns[i].ToString().ToUpper() + "\t");
        }

        wr.WriteLine();

        //write rows to excel file
        for (int i = 0; i < (dt.Rows.Count); i++)
        {
            for (int j = 0; j < dt.Columns.Count; j++)
            {
                if (dt.Rows[i][j] != null)
                {
                    wr.Write(Convert.ToString(dt.Rows[i][j]) + "\t");
                }
                else
                {
                    wr.Write("\t");
                }
            }
            //go to next line
            wr.WriteLine();
        }
        //close file
        wr.Close();
    }
    catch (Exception ex)
    {
        throw ex;
    }

}

And then just call it like this:

C#

ExportToExcel(dt, "FileName");

Hope this works for you !! :) :)

Regards,
Praneet

Praneet Nadkar · Accepted Answer · 2014-10-17T00:17:00

Hi,

For formatting you will have to create a workbook using interop.

Like this:

1.) Create a sample dt, with new row/ break for a column:

C#

System.Data.DataTable dt = new System.Data.DataTable();
            DataSet ds = new DataSet();
            dt.TableName = "tablename";
            dt.Columns.Add("Code", typeof(string));
            dt.Columns.Add("Price", typeof(int));

            DataRow dr = dt.NewRow();
            dr["Code"] = "ABC " + Environment.NewLine + " qrt";
            dr["Price"] = 12;

            dt.Rows.Add(dr);

            DataRow dr1 = dt.NewRow();
            dr1["Code"] = "PQR";
            dr1["Price"] = 1;

            dt.Rows.Add(dr1);

2.) Create the workbook function using Interop.

C#

public static void CreateWorkbook(System.Data.DataTable dt, String path)
    {
        int rowindex = 0;
        int columnindex = 0;

        Microsoft.Office.Interop.Excel.Application wapp = new Microsoft.Office.Interop.Excel.Application();
        Microsoft.Office.Interop.Excel.Worksheet wsheet;
        Microsoft.Office.Interop.Excel.Workbook wbook;

        wapp.Visible = false;

        wbook = wapp.Workbooks.Add(true);
        wsheet = (Worksheet)wbook.ActiveSheet;


        try
        {
            for (int i = 0; i < dt.Columns.Count; i++)
            {
                wsheet.Cells[1, i + 1] = dt.Columns[i].ColumnName;

            }

            foreach (DataRow row in dt.Rows)
            {
                rowindex++;
                columnindex = 0;
                foreach (DataColumn col in dt.Columns)
                {
                    columnindex++;
                    wsheet.Cells[rowindex + 1, columnindex] = row[col.ColumnName];
                }
            }
        }
        catch (Exception ex)
        {
            String err = ex.Message;
        }
        wapp.UserControl = true;

        wbook.SaveAs("d:\\Test", Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal, Type.Missing, Type.Missing,
        false, false, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange,
        Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
        wbook.Close(null,null,null);

3.) To save the file, call the function like this:

C#

CreateWorkbook(dt,"D:/");

You can apply many formatting types to cells, as per your requirement.
Also, this will save automatically, without user prompt.

Regards,
Praneet

Can I Save Excel File In My Local Folder Automatically (Without Asking Any Save Popup) In C# Asp.Net ?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0