将GridView中的数据导出到Excel中
1.需要重写VerifyRenderingInServerForm(Control control)方法
/// <summary>
/// 导出Excel采用此方法 需要重写
/// </summary>
/// <param name="control"></param>
public override void VerifyRenderingInServerForm(Control control)
{
}
2.导出到Excel中的方法
public void ExcelAndManualSign(System.Web.UI.Control ctl, string strFileName)
{
HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + strFileName + ".xls");
HttpContext.Current.Response.Charset = "gb2312";
Htt