Search

Write content to Excel

using System;
using System.IO;
using System.Configuration;
using System.Web.UI;

public partial class _Default : System.Web.UI.Page
{
 protected void Button1_Click(object sender, EventArgs e)
 {
  try
  {
   GridView1.Page.EnableViewState = false;
   StringWriter sWriter = new StringWriter();
   HtmlTextWriter hWriter = new HtmlTextWriter(sWriter);
   GridView1.RenderControl(hWriter);
   string HtmlInfo = sWriter.ToString().Trim();
   FileStream fStream = new FileStream("c:\\data.xls", FileMode.Create);
   BinaryWriter BWriter = new BinaryWriter(fStream);
   BWriter.Write(HtmlInfo);
   BWriter.Close();
   fStream.Close();
   Label1.Text = "File write to c:\\data.xls ";
  }
  catch (Exception ex)
  {
   Label1.Text = ex.ToString ();
  }
 }

 public override void VerifyRenderingInServerForm(Control control)
 {
 }
}