数据导出到excel 2007,该怎么处理

        this.GridView1.AllowPaging = false;     //   Bindcontrols.BindGridView(GridView1, sql);//绑定GridView        Response.Clear();        Response.Buffer = true;        Response.Charset = "GB2312";        Response.Write("<meta http-equiv=Content-Type content=text/html;charset=GB2312>");        Response.AppendHeader("Content-Disposition", "attachment;filename=" + System.Web.HttpUtility.UrlEncode("导出Excel名称"+".xls", System.Text.Encoding.UTF8) + "");        Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");        Response.ContentType = "application/vnd.xls";//设置输出文件类型为excel文件。        System.IO.StringWriter oStringWriter = new System.IO.StringWriter();        System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);        GridView1.RenderControl(oHtmlTextWriter);        Response.Output.Write(oStringWriter.ToString());        Response.Flush();        Response.End();        this.GridView1.AllowPaging = true;//重写控件    private void DisableControls(Control gv)    {        LinkButton lb = new LinkButton();        Literal l = new Literal();        string name = String.Empty;        for (int i = 0; i < gv.Controls.Count; i++)        {            if (gv.Controls[i].GetType() == typeof(Button))            {                l.Text = (gv.Controls[i] as Button).Text;                gv.Controls.Remove(gv.Controls[i]);                gv.Controls.AddAt(i, l);            }            if (gv.Controls[i].GetType() == typeof(LinkButton))            {                l.Text = (gv.Controls[i] as LinkButton).Text;                gv.Controls.Remove(gv.Controls[i]);                gv.Controls.AddAt(i, l);            }            if (gv.Controls[i].GetType() == typeof(System.Web.UI.HtmlControls.HtmlInputText))            {                l.Text = (gv.Controls[i] as System.Web.UI.HtmlControls.HtmlInputText).Value;                gv.Controls.Remove(gv.Controls[i]);                gv.Controls.AddAt(i, l);            }            if (gv.Controls[i].HasControls())            {                DisableControls(gv.Controls[i]);            }        }    }
------解决方案--------------------
C# code
 /// <summary>        /// 根据EXCEL文件名,返回连接字符串        /// </summary>        /// <param name="FileName">Excel文件名</param>        public string GetConnectionString(string fileName)        {            ExcelVersionEnum ev = this.GetExcelVersion(fileName);            string hdr = "HDR=Yes;";            if (this.IsHDR == false) hdr = "HDR=No;";            //HDR  = Yes  把第1行作为字段看待            //IMEX = 1    通知驱动程序始终将“互混”数据列作为文本读取            string connStr = string.Empty;            if (ev == ExcelVersionEnum.Excel2007)                connStr = "Provider=Microsoft.ACE.OLEDB.12.0;" +                               "Data Source = " + @fileName + ";" +                               "Extended Properties=\"Excel 12.0 Xml;" + hdr + "Imex=1;\"";            else                connStr = "Provider = Microsoft.Jet.OLEDB.4.0;" +                    "Data Source = " + @fileName + ";" +                    "Extended Properties=\"Excel 8.0;" + hdr + "Imex=1;\"";                       return connStr;        }
------解决方案--------------------
5楼的办法其实是导出HTML。
其他的没仔细看，楼主可以下载我上传的aspose.cells
http://download.csdn.net/source/1862524
使用参考：http://bokee.shinylife.net/blog/article.asp?id=961