Export to excel not working

See more:

C#

.NET4

ASP.NET4

Dear Friends,

I have an export to excel code which is not running. when i am clicking on the button of ExportToExcel then this code behind code is executed but no response i get from it. Please help.

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

The required html code for the same is:-

<<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" />>