datatable 转 excel

http://www.codeproject.com/Tips/344604/Export-to-EXCEL-from-Datatable-in-Csharp-Net

public void ExportToExcel(DataTable dt)
{
	if (dt.Rows.Count > 0)
	{
		string filename = "DownloadMobileNoExcel.xls"; 
		System.IO.StringWriter tw = new System.IO.StringWriter();
		System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);
		DataGrid dgGrid = new DataGrid();
		dgGrid.DataSource = dt;
		dgGrid.DataBind();

		//Get the HTML for the control.
		dgGrid.RenderControl(hw);
		//Write the HTML back to the browser.
		//Response.ContentType = application/vnd.ms-excel;
		Response.ContentType = "application/vnd.ms-excel";
		Response.AppendHeader("Content-Disposition", "attachment; filename=" + filename + "");
		this.EnableViewState = false;
		Response.Write(tw.ToString());
		Response.End();
	}
}

 Call the above function in button click event

 Collapse | Copy Code

protected void btnSave_Click(object sender, EventArgs e)
{
    ExportToExcel((DataTable)ViewState["gvMobile"]);  
}

 Collapse | Copy Code

public override void VerifyRenderingInServerForm(Control control)

{ 

}