Excel导出(从DataTable)

 

protected void ToExcel(DataTable dt)

    {

        string FileName = "Download" + System.DateTime.Now.ToString("yyyy-MM-dd hh:mm") + ".xls";

        StringWriter sw = new StringWriter();

        int CoulumnCount = dt.Columns.Count;

        //标题

        string strTitle="";

        for (int i = 0; i < CoulumnCount; i++)

        {

            if (i == CoulumnCount - 1)

            {

                strTitle += dt.Columns[i].ColumnName;

            }

            else { strTitle += dt.Columns[i].ColumnName + ","; }

        }

        sw.WriteLine(strTitle);

 

        //写数据

        foreach (DataRow dr in dt.Rows)

        {

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

            {

                if (dt.Columns[i].ColumnName == "身份证")

                {

                    sw.Write("’" + dr[i].ToString());

                }

                else { sw.Write(dr[i].ToString()); }

                sw.Write(",");

            }

            sw.WriteLine("/n");

        }

        sw.Close();

 

        Response.Clear();

        Response.ContentType = "applicationg/ms-excel";

        Response.ContentEncoding = System.Text.Encoding.UTF8;

        Response.Output.Write(sw);

        Response.Close();

}