导出到excel

/// /// DataTable中的数据导出到Excel并下载 ///

///要导出的DataTable

///类型

///Excel的文件名

private void CreateExcel(DataTable dt, string FileName)

{

        Response.Clear();

        Response.Charset = "UTF-8";

        Response.Buffer = true; Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");

        Response.AppendHeader("Content-Disposition", "attachment;filename=\"" + System.Web.HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8));         Response.ContentType = "application/ms-excel";

         string colHeaders = string.Empty; string ls_item = string.Empty;

        DataRow[] myRow = dt.Select();

        int i = 0; int cl = dt.Columns.Count;

        foreach (DataColumn column in dt.Columns)

        {         

                ls_item += column.ColumnName + "\t"; //context.Response.Write(column.ColumnName + "(" + column.DataType + "),");

        }         

        ls_item += "\n";

        foreach (DataRow row in myRow)

        {

                for (i = 0; i < cl; i++)

                {

                         if (i == (cl - 1))

                         {

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

                        }

                else {

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

                        }

                 }

                 Response.Output.Write(ls_item); ls_item = string.Empty;

        }

Response.Output.Flush();

Response.End();

}

#endregion

///导出

private void DownloadExcel(string saleOrderIDs)

{

        XTFPS.BLL.saleOrder bll = new XTFPS.BLL.saleOrder();

        string filename = USER.UserName+ "老板电器信息.xls";

        string path = Server.MapPath(filename);

        DataSet myds = bll.ExportExcel(saleOrderIDs);

        if (myds != null && myds.Tables["OperSaleOrderList"].Rows.Count > 0)                 CreateExcel(myds.Tables["OperSaleOrderList"], filename);

        else

                JSTools.MessageBox(this, "查询数据为空！");

}