c# – .NET导出到excel – 未显示子行

发布时间：2020-12-15 22:48:30 所属栏目：百科来源：网络整理

导读：在我的asp.net应用程序中,我让用户通过单击按钮从视图中导出一些数据.下面的代码导出一个excel文件.问题是我无法弄清楚如何显示对象的模型列表. var grid = new GridView(); grid.DataSource = exportModels; grid.DataBind(); Response.ClearContent(); Res

在我的asp.net应用程序中,我让用户通过单击按钮从视图中导出一些数据.下面的代码导出一个excel文件.问题是我无法弄清楚如何显示对象的模型列表.

var grid = new GridView();
        grid.DataSource = exportModels;
        grid.DataBind();

        Response.ClearContent();
        Response.AddHeader("content-disposition","attachment; filename=Exported_Orders.xls");
        Response.ContentType = "application/excel";
        StringWriter sw = new StringWriter();
        HtmlTextWriter htw = new HtmlTextWriter(sw);

        grid.RenderControl(htw);

        Response.Write(sw.ToString());

        Response.End();

数据源模型是这样的：

public class ExportOrdersViewModel
    {
        public int Id { get; set; }
        public string CustomerFirstName { get; set; }
        public string CustomerLastName { get; set; }
        public string CustomerEmail { get; set; }
        public string CustomerMobile { get; set; }
        public string ShippingStreet { get; set; }
        public string ShippingCity { get; set; }
        public string ShippingCountry { get; set; }
        public string ShippingPostalCode { get; set; }
        public string ShippingTo { get; set; }
        public bool IsShipped { get; set; }
        public ICollection<ExportOrdersItemViewModel> Items { get; set; }

    }

    public class ExportOrdersItemViewModel
    {
        public string TicketName { get; set; }
        public string EventName { get; set; }
        public int Quantity { get; set; }
        public string CurrencyId { get; set; }
        public string PaymentCurrencyId { get; set; }
        public string UnitPrice { get; set; }
        public string PaymentUnitPrice { get; set; }
    }

ExportOrderViewModel包含ExportOrderItemViewModel的列表,并且在导出文件时,该文件中缺少每个订单的项行.我真的需要一些关于如何在导出时添加这些字段的帮助.

以下是导出文件的标题：

enter image description here

这是网格对象在创建excel文件之前包含的内容：

enter image description here

解决方法

正如@Crowcoder建议的那样,我使用了CLoseXML库,最终成功找到了解决问题的方法.

这是生成我想要的Excel的代码

using (var workBook = new XLWorkbook())
            {
                var workSheet = workBook.Worksheets.Add("Guests");

                var guestTable = new DataTable();
                guestTable.Columns.Add(Resources.Strings.FirstName,typeof(string));
                guestTable.Columns.Add(Resources.Strings.LastName,typeof(string));
                guestTable.Columns.Add(Resources.Strings.TicketName,typeof(string));
                guestTable.Columns.Add(Resources.Strings.TicketType,typeof(string));
                guestTable.Columns.Add(Resources.Strings.ShortCode,typeof(string));
                guestTable.Columns.Add(Resources.Strings.HasVisitorEnteredEvent,typeof(string));
                foreach (var entry in guestList)
                {
                    guestTable.Rows.Add(
                        entry.FirstName,entry.LastName,entry.TicketName,entry.TicketType,entry.ShortCode,entry.HasEntered);
                }
                workSheet.Cell(1,1).InsertTable(guestTable);
                workSheet.Tables.ForEach(t => t.ShowAutoFilter = false);
                workSheet.Style.Alignment.Vertical = XLAlignmentVerticalValues.Center;
                workSheet.Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Center;
                workSheet.Tables.ForEach(t => t.Theme = XLTableTheme.TableStyleLight13);
                workSheet.Columns().AdjustToContents();
                workBook.SaveAs(outputStream);
            }

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!