Response.Clear(); Response.AddHeader("content-disposition", "attachment;filename=Stock_Statement.xls"); Response.Charset = ""; // If you want the option to open the Excel file without saving then // comment out the line below // Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.ContentType = "application/vnd.xls"; System.IO.StringWriter stringWrite = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite); #region ExcelExportCode //Added by Ashish Naval on 06Dec2011 for Paging functionality on GridView //grdMainPrintXLFull.RenderControl(htmlWrite); dvView.RenderControl(htmlWrite); //************************************************************************ Response.Write(stringWrite.ToString()); Response.End(); #endregion
<<HeaderTemplate> Cost Center Name </HeaderTemplate> <HeaderStyle HorizontalAlign="Center" /> <HeaderTemplate> Item </HeaderTemplate> <HeaderStyle HorizontalAlign="Center" /> <HeaderTemplate> Item Code</HeaderTemplate> <HeaderStyle HorizontalAlign="Center" /> <HeaderTemplate> Item Description</HeaderTemplate> <HeaderStyle HorizontalAlign="Center" /> <HeaderTemplate> UOM </HeaderTemplate> <HeaderStyle HorizontalAlign="Center" /> <HeaderTemplate> Item Nature</HeaderTemplate> <HeaderStyle HorizontalAlign="Center" /> <HeaderTemplate> Opening Balance </HeaderTemplate> <HeaderStyle HorizontalAlign="Center" /> <HeaderTemplate> In QTY </HeaderTemplate> <HeaderStyle HorizontalAlign="Center" /> <HeaderTemplate> Out QTY </HeaderTemplate> <HeaderStyle HorizontalAlign="Center" /> <HeaderTemplate> Balance QTY </HeaderTemplate> <HeaderStyle HorizontalAlign="Center" /> <HeaderTemplate> MSL </HeaderTemplate> <HeaderStyle HorizontalAlign="Center" /> <HeaderTemplate> Weighted Rate </HeaderTemplate> <HeaderStyle HorizontalAlign="Center" /> <HeaderStyle BackColor="#acd030" Height="26px" /> <HeaderTemplate> Cost Center Name </HeaderTemplate> <HeaderStyle HorizontalAlign="Center" /> <HeaderTemplate> Item </HeaderTemplate> <HeaderStyle HorizontalAlign="Center" /> <HeaderTemplate> Item Code</HeaderTemplate> <HeaderStyle HorizontalAlign="Center" /> <HeaderTemplate> Item Description</HeaderTemplate> <HeaderStyle HorizontalAlign="Center" /> <HeaderTemplate> Item Nature</HeaderTemplate> <HeaderStyle HorizontalAlign="Center" /> <HeaderTemplate> Primary UOM </HeaderTemplate> <HeaderStyle HorizontalAlign="Center" /> <HeaderTemplate> Opening Balance </HeaderTemplate> <HeaderStyle HorizontalAlign="Center" /> <HeaderTemplate> In QTY </HeaderTemplate> <HeaderStyle HorizontalAlign="Center" /> <HeaderTemplate> Out QTY </HeaderTemplate> <HeaderStyle HorizontalAlign="Center" /> <HeaderTemplate> Balance QTY </HeaderTemplate> <HeaderStyle HorizontalAlign="Center" /> <HeaderTemplate> MSL </HeaderTemplate> <HeaderStyle HorizontalAlign="Center" /> <HeaderTemplate> Secondary UOM </HeaderTemplate> <HeaderStyle HorizontalAlign="Center" /> <HeaderTemplate> Balance QTY </HeaderTemplate> <HeaderStyle HorizontalAlign="Center" /> <HeaderTemplate> Weighted Rate </HeaderTemplate> <HeaderStyle HorizontalAlign="Center" /> <HeaderStyle BackColor="#acd030" Height="26px" />>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)