Create and save xls files in c#

Question

Hi, I'm trying to create an xls files using c# like this

protected void ExportToExcel(DataSet dset, int TableIndex, HttpResponse Respone, string Felename)
    {
        Respone.Clear();
        Respone.Charset = "";
        Respone.ContentType = "application/vnd.ms-excel";
        Respone.AddHeader("content-disposition", "attachment; filename=" + Felename + ".xls");
        System.IO.StringWriter sw = new System.IO.StringWriter();

        System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);
        GridView gv = new GridView();
        gv.DataSource = dset.Tables[TableIndex];
        gv.DataBind();
        gv.RenderControl(hw);
        Respone.Write(sw.ToString());
        Respone.End();
    }

It is working fine for me. But it is opening that created xls file after successfull completion. But i want to save the file in my folder without opening and asking my permision.

How can i save automatically..

Thanks in advance

Answer 1

Change the content-type to application/x-unknown - depending on the browser this should only offer a save option as it won't recognise it as an Excel file.

Also, be aware that you are actually just saving an HTML file with an Excel extension, it isn;t a true Excel file.

Answer 2

SpreadsheetGear for.NET can save to an Excel workbook from a DataTable.

See the DataTable to Excel Workbook C# or VB sample on the SpreadsheetGear ASP.NET Excel Reporting Sample page here.

You can download a free trial here if you want to try it yourself.

Disclaimer: I own SpreadsheetGear LLC

Answer 3

This SO thread and answer link here is a good approach.