导出Excel

最新推荐文章于 2022-07-19 08:39:51 发布

csdn_senlin

最新推荐文章于 2022-07-19 08:39:51 发布

阅读量626

点赞数

分类专栏：技术点文章标签：导出Excel

本文链接：https://blog.csdn.net/senlin20/article/details/19621871

版权

技术点专栏收录该内容

5 篇文章 0 订阅

订阅专栏

/// <summary>
        /// Repeater 导出E
        /// </summary>
        /// <param name="ctl"></param>
        public void ReportToExcel(List<QJProblemTasks> results)
        {

StringWriter sw = new StringWriter();

            sw.WriteLine("城区\t道路名称\t道路类型\t问题时间\t问题类型\t详细地址");
            foreach (var i in results)
            {
                DateTime issueDate = new DateTime();

                if (i.IssueTime == null)
                    issueDate = i.CheckTime;
                else
                    issueDate = i.IssueTime.Value;

                sw.Write(i.DistrictName + "\t" + i.RoadName + "\t" + i.RoadTypeName + "\t" + issueDate.ToString() +
                        "\t" + i.RuleName + "\t" +
                        i.Address);

                sw.WriteLine();
            }
            sw.Close();
            Response.AddHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode("我的问题", System.Text.Encoding.UTF8) + ".xls");
            Response.ContentType = "application/ms-excel";
            Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
            Response.Write(sw);
            Response.End();
        }