/// <summary>
///导出Excel
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ToExcel2()
{
// Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=FileName.xls");
Response.Charset = "gb2312";
Response.ContentType = "application/vnd.xls";
Response.ContentEncoding = System.Text.Encoding.UTF8;
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
GridView1.AllowPaging = false;//导出前先取消分页,以便能将所有数据导出。
GridView1.RowStyle.BackColor = Color.White;
GridView1.AlternatingRowStyle.BackColor = Color.White;
// GridView1.DataBind();//再重新绑定一次数据
string sqlstr = getSQlStr();
bind(sqlstr); //绑定
int m = GridView1.Columns.Count;
for (int i = 0; i < GridView1.Rows.Count; i++)
{
GridView1.Rows[i].Cells[m - 1].Visible = false;
GridView1.Rows[i].Cells[m - 1].Enabled = false;
}
GridView1.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
// GridView1.AllowPaging = true;//导出后先取消分页,以便能将所有数据导出。
GridView1.DataBind();//再重新绑定一次数据
}