//根据DataSet导出Excel表
protected void InputExcel(DataSet ds)
{
Response.Clear();
Response.AddHeader("content-disposition","online:filename=userInfo.xls");
Response.ContentType = "application/vnd.ms-excel";
Response.Charset = "GB2312";
System.IO.StringWriter sw = new System.IO.StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
GridView dg = new GridView();
dg.DataSource = ds;
dg.DataBind();
dg.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}