c# Asp.net生成Excel

最新推荐文章于 2023-09-13 10:32:57 发布

weixin_30757793

最新推荐文章于 2023-09-13 10:32:57 发布

阅读量88

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/newmin/archive/2009/07/07/1518591.html

本文介绍了一种将数据从DataTable导出到Excel文件的方法。通过遍历DataTable中的所有列和行，将其转换为字符串格式并使用制表符进行分隔，最终通过HTTP响应将生成的Excel文件提供给用户下载。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

    public static void ProductTeacherReport(DataTable dts)
    {

        DataTable dt = dts;
        if (dt.Rows.Count == 0) return;
        System.Text.StringBuilder sb = new System.Text.StringBuilder();
        MemoryStream ms = new MemoryStream();
        foreach (DataColumn dc in dt.Columns)
        {
            sb.Append(dc.ColumnName + Convert.ToChar(9));
        }

        for (int i = 0; i < dt.Rows.Count; i++)
        {
            sb.Append("\r");
            for (int j = 0; j < dt.Columns.Count; j++)
            {

                sb.Append( dt.Rows[i][j].ToString() + Convert.ToChar(9));
            }
        }
        StreamWriter sw = new StreamWriter(ms);
        sw.Write(sb.ToString());

        string fileName ="teacher_" + DateTime.Now.Ticks + ".xls";
        HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;fileName=" + fileName);
        HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.Unicode;
        HttpContext.Current.Response.ContentType = "application/ms-excel";
        HttpContext.Current.Response.BinaryWrite(ms.ToArray());
    }

没有时间写注释说明，上班偷偷发的哦

转载于:https://www.cnblogs.com/newmin/archive/2009/07/07/1518591.html