将DataSet中的数据导出到Excel表中

    实例代码：

    /// <summary>

    /// 导出Excel数据

    /// </summary>

    /// <param name="ds"></param>

    /// <param name="typeid"></param>

    /// <param name="FileName"></param>

    public void CreateExcel(DataSet ds, string typeid, string FileName)

    {

        HttpResponse resp;

        resp = Page.Response;

        resp.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");

        resp.ContentType = "application/ms-excel";

        resp.AddHeader("Content-Disposition",

"attachment; filename=" + System.Web.HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8) + ".xls");

        this.EnableViewState = false;

        string colHeaders = "", Is_item = "";

        int i = 0;

        //定义表对象与行对象，同时使用DataSet对其值进行初始化

        DataTable dt = ds.Tables[0];

        DataRow[] myRow = dt.Select("");

        //typeid=="1"时导出为Excel格式文件;typeid=="2"时导出为XML文件

        if (typeid == "1")

        {

            //取得数据表各列标题，标题之间以/t分割，最后一个列标题后加回车符

            for (i = 0; i < dt.Columns.Count; i++)

            {

                colHeaders += dt.Columns[i].Caption.ToString() + "/t";

            }

            colHeaders += "/n";

            resp.Write(colHeaders);

            //逐行处理数据

            foreach (DataRow row in myRow)

            {

                //在当前行中，逐列取得数据，数据之间以/t分割，结束时加回车符/n

                for (i = 0; i < dt.Columns.Count; i++)

                {

                    Is_item += row[i].ToString() + "/t";

                }

                Is_item += "/n";

                resp.Write(Is_item);

                Is_item = "";

            }

        }

        else

        {

            if (typeid == "2")

            {

                //从DataSet中直接导出XML数据并且写到HTTP输出流中

                resp.Write(ds.GetXml());

            }

        }

        //写缓冲区中的数据到HTTP头文件中

        resp.End();

    } 

调用方法：

    /// <summary>

    /// 导出当前省份的所有数据

    /// </summary>

    /// <param name="sender"></param>

    /// <param name="e"></param>

    protected void lkbNowData_Click(object sender, EventArgs e)

    {

        string strArea = this.ddlAreaType.SelectedValue.ToString();

        DataSet ds = new Sheet_Z_SQL().GetSheetByArea(strArea);

        CreateExcel(ds, "1", "LenovoSheet");

    }