Thursday, May 22, 2014

How to open a Print view from excel;


         




        Response.ClearContent();
        Response.AddHeader("content-disposition", "attachment; filename=GridViewToExcel.xls");
        Response.ContentType = "application/excel";
        StringWriter sWriter = new StringWriter();
        HtmlTextWriter hTextWriter = new HtmlTextWriter(sWriter);
        HtmlForm hForm = new HtmlForm();
        RegionalGrid.Parent.Controls.Add(hForm);
        hForm.Attributes["runat"] = "server";
        hForm.Controls.Add(RegionalGrid);
        hForm.RenderControl(hTextWriter);
        Response.Write(sWriter.ToString());
        Response.End();

No comments: