使用GridView导出Excel的方法把GridView中的内容导出为Excel:
/// <summary>
/// 将网格数据导出到Excel
/// </summary>
/// <param name="ctrl">网格名称(如GridView1)</param>
/// <param name="FileType">要导出的文件类型(Excel:application/ms-excel)</param>
/// <param name="FileName">要保存的文件名</param>
public void GridViewToExcel(Control ctrl, string FileType, string FileName)
{
bool gridViewAllowPaging = false;
if (ctrl is GridView)
{
gridViewAllowPaging = ((GridView)ctrl).AllowPaging;
if (gridViewAllowPaging)
{
((GridView)ctrl).AllowPaging = false;
}
}
HttpContext.Current.Response.Charset = "GB2312";
HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF8;//注意编码
HttpConte