拼接的字符串导入EXCEL

最新推荐文章于 2024-03-27 10:14:50 发布

置顶 wanglei_samrtfish

最新推荐文章于 2024-03-27 10:14:50 发布

阅读量1.7k

点赞数 1

CC 4.0 BY-SA版权

分类专栏： asp.net学习总结文章标签： string border excel list

本文链接：https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/7578903

asp.net学习总结专栏收录该内容

103 篇文章

订阅专栏

StringBuilder sb = new StringBuilder();
            sb.AppendLine("<table><tr><th>序号</th><th>批单号</th><th>保单号</th><th>被保险人</th><th>保全项目</th><th>退费金额</th><th>保全操作日期</th><th>经办人</th></tr>");
            int i = 1;
            string str = "abc";
            string str1 = "wanglei";
            string str2 = "aaa";
            string time1 = DateTime.Now.ToString();
            sb.AppendLine("<tr><td>1</td><td style=\"vnd.ms-excel.numberformat:@\">" + 243123 + "</td><td style=\"vnd.ms-excel.numberformat:@\">" + str + "</td><td>" + str1 + "</td><td>" + str2 + "</td><td>" + "</td><td>" + time1 + "</td><td>" + str + "</td></tr>");
            //foreach (BillChange change in list)
            //{
            //    sb.AppendLine("<tr><td>" + (i++).ToString() + "</td><td style=\"vnd.ms-excel.numberformat:@\">" + change.ChangeBillCode + "</td><td style=\"vnd.ms-excel.numberformat:@\">" + change.BillCode + "</td><td>" + change.BillHolder + "</td><td>" + GetChangeTypeString(change.ChangeType) + "</td><td>" + (change.ReturnFee > 0 ? change.ReturnFee.ToString() : "") + "</td><td>" + change.CreateDatetime.ToString("yyyy-MM-dd") + "</td><td>" + change.CreatorName + "</td></tr>");
            //}
            sb.Insert(0, "<html><head><meta content='text/html; charset=utf-8' http-equiv='content-type' /></head><body><table border=1>");
            sb.AppendLine("</table></body></html>");

            Response.Clear();
            Response.Buffer = true;
            Response.Charset = "UTF-8";
            Response.AppendHeader("Content-Disposition", "attachment;filename=\"" + Server.UrlEncode("保单变更信息.xls") + "\"");
            Response.ContentEncoding = Encoding.UTF8;
            Response.ContentType = "application/ms-excel";
            Response.Write(sb.ToString());
            Response.End();