真爱无限的知识驿站

code:

            var data = GetDataList();
            string fileName = string.Format("export{0}", DateTime.Now.ToString("yyyyMMddHHmmssff"));
            Response.AppendHeader("Content-Disposition", "attachment;filename=" + fileName + ".xls");
            //Response.Charset = "gb2312";
            Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
            Response.ContentType = "application/ms-excel";
            StringBuilder sb = new StringBuilder();
            sb.Append("<table border='1'>");
            sb.Append("<tbody>");
            sb.Append("<tr>");
            sb.Append("<th>链接ID</th>");
            sb.Append("<th>链接名称</th>");
            sb.Append("<th>产品名称</th>");
            sb.Append("<th>酒景名称</th>");
            sb.Append("<th>省份</th>");
            sb.Append("<th>审核状态</th>");
            sb.Append("<th>上架时间</th>");
            sb.Append("<th>下架时间</th>");
            sb.Append("<th>归属人</th>");
            sb.Append("<th>流量电话</th>");
            sb.Append("</tr>");
            sb.Append("</tbody>");
            foreach (var item in data)
            {
                int productCount = item.Packages.Sum(m => { return m.Products.Count; });
                sb.AppendFormat("<tr>");
                sb.AppendFormat("<td rowspan=\"{1}\">{0}</td>", item.ChannelLinkId, productCount);
                sb.AppendFormat("<td rowspan=\"{1}\">{0}</td>", item.ChannelLinkName, productCount);
                sb.AppendFormat("<td rowspan=\"{1}\">{0}</td>", item.Packages[0].PackageName, item.Packages[0].Products.Count);
                sb.AppendFormat("<td>{0}</td>", item.Packages[0].Products[0].ProductName);
                sb.AppendFormat("<td>{0}</td>", item.Packages[0].Products[0].ProvinceName);
                sb.AppendFormat("<td rowspan=\"{1}\">{0}</td>", item.AuditStatus, productCount);
                sb.AppendFormat("<td rowspan=\"{1}\">{0}</td>", item.StartDate, productCount);
                sb.AppendFormat("<td rowspan=\"{1}\">{0}</td>", item.EndDate, productCount);
                sb.AppendFormat("<td rowspan=\"{1}\">{0}</td>", item.BDName, productCount);
                sb.AppendFormat("<td rowspan=\"{1}\">{0}</td>", item.BDTel, productCount);
                sb.AppendFormat("</tr>");
                for (int i = 0; i < item.Packages.Count; i++)
                {
                    var p = item.Packages[i];
                    if (i == 0)
                    {
                        if (p.Products.Count > 1)
                        {
                            for (int k = 1; k < p.Products.Count; k++)
                            {
                                sb.AppendFormat("<tr>");
                                sb.AppendFormat("<td>{0}</td>", p.Products[k].ProductName);
                                sb.AppendFormat("<td>{0}</td>", p.Products[k].ProvinceName);
                                sb.AppendFormat("</tr>");
                            }
                        }
                    }
                    else
                    {
                        sb.AppendFormat("<tr>");
                        sb.AppendFormat("<td rowspan=\"{1}\">{0}</td>", p.PackageName, p.Products.Count);
                        if (p.Products.Count > 0)
                        {
                            sb.AppendFormat("<td>{0}</td>", p.Products[0].ProductName);
                            sb.AppendFormat("<td>{0}</td>", p.Products[0].ProvinceName);
                            for (int k = 1; k < p.Products.Count; k++)
                            {
                                sb.AppendFormat("<tr>");
                                sb.AppendFormat("<td>{0}</td>", p.Products[k].ProductName);
                                sb.AppendFormat("<td>{0}</td>", p.Products[k].ProvinceName);
                                sb.AppendFormat("</tr>");
                            }
                        }
                        sb.AppendFormat("</tr>");
                    }
                }
            }
            sb.AppendFormat("</table>");
            LogUtility.WriteLog(string.Format("请求结果，返回文件：contentlength:{0}", sb.Length), false);
            Response.Write(sb);
            Response.End();

导出后的文件名是xls格式，直接用excel打开正常

不过，用notepad++打开excel文件，里面的内容有些变化，估计是导出时转化Content-Type时.Net web做的一些自动处理。