Monday, June 9, 2008

Export whole page to excel

Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=AnalyzeData.xls");
Response.Charset = "";
Response.ContentType = "~/ReportOutputs/abc.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
if (Session["griddata"] != null)
{
DataTable dt = (DataTable)Session["griddata"];
for (int i = 0; i < dt.Rows.Count;i++ )
{
((HyperLink)GridView1.Rows[i].FindControl("hyplnkedit")).NavigateUrl="";
}
}
htmlWrite.WriteLine("Analyze Criteria");
htmlWrite.WriteBreak();
form1.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();

No comments: