Hi friends,

    I want to read data from sql server db and export that data to excel sheet. I have a template excel file in which formulas are defined and a graph is placed.

I want to use this template and create new excel file and the filename is specified on the fly.

How can I do it in asp.net?

Somewhere I found that to add reference for Microsoft.Excel 11.0 library

and import the namespace, using System.Runtime.InteropServices.Marshal

in the event procedures, Excel.Application exl = ...

I am not getting the Excel. intellisence popup

Any reply is highly appreciated.

This will get you started on Excel Object Model: http://msdn.microsoft.com/en-us/library/aa168292(office.11).aspx

Hi rajkm42,

Export data to Excel is one of the most common functionality required in ASP.Net pages. Here are many references talking about this.

And I found some of them quoted here. You may have a look at them

http://www.codeproject.com/KB/custom-controls/Excel_CSV_export_button.aspx

http://www.c-sharpcorner.com/uploadfile/dipalchoksi/exportaspnetdatagridtoexcel11222005041447am/exportaspnetdatagridtoexcel.aspx

http://www.developer.com/net/asp/article.php/3633891

Best Regards,
Shengqing Yang

string strFileName;

DataGrid dg
        Response.ClearContent();
        Response.AddHeader("content-disposition", "attachment; filename=" + strFileName);
        Response.ContentType = "application/excel";
        System.IO.StringWriter sw = new System.IO.StringWriter();
        HtmlTextWriter htw = new HtmlTextWriter(sw);
        dg.RenderControl(htw);
        Response.Write(sw.ToString());
        Response.End();

I export data  from gridview to file excel to appear error font.It only true when run at localhost and error font when run in server

please ,help me.