web页导出excel
public void ExportExcelBrand() { string elxStr = ""; string body = ""; List<BrandRemindTB> list = this.BaseService.GetModelList<BrandRemindTB>(u => u.MemberID == this.MemberContext.MemberTB.ID); foreach (var item in list) { body += "<tr><td>" + item.Type + "</td><td>" + item.Number + "</td><td>" + item.BrandName + "</td><td>" + item.AppName + "</td><td>" + item.AppDate.ToString("yyyy-MM-dd") + "</td><td>" + (item.EndDate == null ? "" : ((DateTime)item.EndDate).ToString("yyyy-MM-dd")) + "</td><td>" + item.Status + "</td></tr>"; } elxStr += "<table>" + "<th><tr><td>类型</td><td>注册号</td><td>商标名称</td><td>申请人</td><td>申请日期</td><td>到期日期</td><td>状态</td></tr></th>" + "<tbody>" + body + "</tbody>" + "</table>"; Response.Clear(); Response.Buffer = true; Response.AppendHeader("Content-Disposition", "attachment;filename=" + IDGenerator.DateTimeAndNumber() + ".xls"); Response.ContentEncoding = System.Text.Encoding.UTF8; Response.ContentType = "application/vnd.ms-excel"; Response.Write(elxStr); Response.End(); }