Freigeben über

Html Export to Excel

  • Artikel

Html Export to Excel

for exporting to excel just call the function below in sample code and pass the page object from an aspx and the aspx page contents are rendered in excel..

make control.visible = false in the page if you dont want those controls to be exported to excel.

the same function can be overloaded to pass say a datagrid (in most search screens we need results only)also.

 

// For Direct Exporting From  HTML to excel
  // Call this function on Button Click
  public static void HtmlExportToExcel(Page PageObject)

  {
 
   HttpContext.Current.Response.Buffer = true;
   HttpContext.Current.Response.Clear();

   HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";

   HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.Default;
   HttpContext.Current.Response.AddHeader("content-disposition",
    "attachment; filename=Export-" + System.DateTime.Now.ToString("MMMddyyyy-hhmmtt") +   ".xls");
   HttpContext.Current.Response.Charset = string.Empty ;

   PageObject.EnableViewState = false;

   StringWriter tw = new StringWriter();

   HtmlTextWriter hw = new HtmlTextWriter(tw);

   PageObject.RenderControl (hw);
      HttpContext.Current.Response.Write(tw.ToString());

   HttpContext.Current.Response.Flush() ;

   HttpContext.Current.Response.Close();
  }