CreateExcel(ExcelDs, "", f);

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

        {

            HttpResponse resp = System.Web.HttpContext.Current.Response;

            // Response.ContentEncoding

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

            resp.AppendHeader("Content-Disposition", "attachment;filename=" + FileName);

            resp.Charset = "UTF-8";

            string colHeaders = "", ls_item = "";

            int i = ;

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

            DataTable dt = ds.Tables[];

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

            // typeid=="1"时导出为EXCEL格式文件；typeid=="2"时导出为XML格式文件

            if (typeid == "")

            {

                resp.ContentType = "application/ms-excel";//image/JPEG;text/HTML;image/GIF;vnd.ms-excel/msword

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

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

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

                colHeaders += GetColumnNamePinYin(dt.Columns[i].Caption).ToString() + "\n";

                //向HTTP输出流中写入取得的数据信息

                resp.Write(colHeaders);

                //逐行处理数据

                foreach (DataRow row in myRow)

                {

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

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

                    {

                        if (row[i].ToString().Length == )

                            ls_item += row[i].ToString().Replace("\t", "") + "帆" + "\t";

                        else if (row[i].ToString().Contains("-") && row[i].ToString().Contains(":"))

                        {

                            ls_item += Convert.ToDateTime((row[i])).ToString("yyyy-MM-dd").Replace("\t", "") + "\t";

                        }

                        else

                            ls_item += row[i].ToString().Replace("\t", "") +""+ "\t";

                    }

                    // ls_item += GetKeFuByPinYin(row[i].ToString()).Replace("\t", "") + "\n";

                    ls_item += row[i].ToString().Replace("\t", "") + "\n";

                    //当前行数据写入HTTP输出流，并且置空ls_item以便下行数据

                    resp.Write(ls_item);

                    ls_item = "";

                }

            }

            else

            {

                if (typeid == "")

                {

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

                    resp.Write(ds.GetXml());

                }

            }

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

            resp.End();

        }