public ActionResult ExportExcel()
{
string xmlData = HttpContext.Server.MapPath("~/App_Data/GridColumn.xml");//Path of the xml script
DataSet ds = new DataSet();//Using dataset to read xml file
ds.ReadXml(xmlData);
DataTable dtRecords = ds.Tables[0];// Data Table
int recordsCount = dtRecords.Rows.Count;
var grid = new GridView();
grid.DataSource = dtRecords;
grid.DataBind();
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename=MyExcelFile.xls");
Response.ContentType = "application/ms-excel";
Response.Charset = "";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
DownloadFileActionResult download = new DownloadFileActionResult(grid, "Cars.xls");
download.ExecuteResult(this.ControllerContext);
grid.RenderControl(htw);
Response.Output.Write(htw.ToString());
Response.Flush();
Response.End();
return new EmptyResult();
}
public void IgnoresChildren ()
{
Button b = new Button ();
b.Controls.Add (new LiteralControl ("hola"));
Assert.AreEqual (1, b.Controls.Count, "controls");
StringWriter sw = new StringWriter ();
HtmlTextWriter tw = new HtmlTextWriter (sw);
b.RenderControl (tw);
string str = tw.ToString ();
Assert.AreEqual (-1, str.IndexOf ("hola"), "hola");
}
/// <summary>
/// Renders The Given Control Into The String Output
/// </summary>
/// <param name="control">The WebControl To Be Converted</param>
/// <returns>The Rendered Result Of The Given Control</returns>
///
private static string GetControl(WebControl control)
{
StringWriter stringWriter = new StringWriter();
HtmlTextWriter textWriter = new HtmlTextWriter(stringWriter);
control.RenderControl(textWriter);
textWriter.Flush();
return textWriter.ToString();
}
