.NET 简单导出CSV文件

最新推荐文章于 2024-06-29 07:00:00 发布

weixin_30569001

最新推荐文章于 2024-06-29 07:00:00 发布

阅读量316

点赞数

原文链接：http://www.cnblogs.com/smileZeng/p/8867016.html

版权

        Response.ClearContent();
        Response.AddHeader("content-disposition", "attachment; filename=" + DateTime.Now.ToString("yyyy-MM-dd") + ".csv");
        Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
        Response.ContentType = "application/excel";
        System.Text.StringBuilder sb = new System.Text.StringBuilder();

        /* 这里自由需要添加数据  */ 
        sb.Append("ID,title,content\r\n");            //标题
        sb.Append("1,标题,内容\r\n");                //行

        /*
        //用DataTable获取的数据
        string str = "";
        foreach (System.Data.DataRow dr in dt.Rows)
        {
            str = "";
            foreach (object r in dr.ItemArray)
            {
                str += r.ToString() + ",";
            }
            str = str.Substring(0, str.Length - 1) + "\r\n";
            sb.Append(str);
        }
        */
 
        Response.Write(sb.ToString());
        Response.End();