<asp:UpdatePanel ID="UpdatePanel2" runat="server"> <ContentTemplate> <asp:LinkButton ID="ExportExcel" runat="server" OnClick="ExportTabletoExcel_Click" OnClientClick="ExportTableJqueryMethod">ExportExcel</asp:LinkButton> </ContentTemplate> <Triggers> <asp:PostBackTrigger ControlID="ExportExcel" /> </Triggers> </asp:UpdatePanel>
using Excel1= Microsoft.Office.Interop.Excel; ... protected void ExportTabletoExcel_Click(object sender, EventArgs e) { Excel1.Application excelApp = new Excel1.Application(); ...//Adding Data to Excel excelWorkBook.SaveAs(path, Excel1.XlFileFormat.xlWorkbookNormal); excelWorkBook.Close(); ...//to download HttpContext.Current.Response.ContentType = "application/xls"; HttpContext.Current.Response.AppendHeader("content-disposition", "attachment; > filename=ExportedExcel.xls"); HttpContext.Current.Response.WriteFile(path + ".xls"); }
<add assembly="Microsoft.Office.Interop.Excel, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"/>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)