Pivot table could not work about closedxml.report HOT 15 CLOSED

               using (var memory = new MemoryStream())
                {
                    template.SaveAs(memory);
                    memory.Position = 0;

                    var response = new XmlReportResponse
                    {
                        File = memory.ToArray()
                    };
                    return response;
                }

    public void Report(string file_path)
    {
        string outputFile = file_path + "\\xxx.xlsx";
        var template = new XLTemplate(file_path+ "\\tPivot1.xlsx");
        try
        {

            Customer cust = new Customer();
            //cust.CustNo = 1;
            //cust.Company = "Company ABC";
            List<order> orders = new List<order>();
            for (int i = 0; i < 10; i++)
            {
                order myorder = new order();
                myorder.OrderNo = i + 1;
                //myorder.ShipToAddr1 = "AA " + i;
                myorder.AmountPaid = i;
                orders.Add(myorder);

            }
            cust.Orders = orders;
            template.AddVariable(new { orders = orders });
            template.Generate();
            template.SaveAs(outputFile);

        }
        catch(Exception ex)
        {

        }
    }

public byte[] GenerateXmlReport(XmlReportGeneratorRequestDTO data)
{
    string templateName = data.TemplateName ?? throw new ArgumentNullException("Отсутствует имя шаблона.");

    var dataSets = new Dictionary<string, object[]>();

    if (data.Data == null || data.Data.Count == 0) throw new ArgumentNullException("Нет данных.");

    foreach (var item in data.Data.Select((d, i) => new { d, i }))
    {
        dataSets.Add($"data{item.i}", item.d.ToArray());
    }

    var template = FindAndLoadTemplate(templateName);

    foreach (var ds in dataSets)
    {
        template.AddVariable(ds.Key, ds.Value);
    }

    var res = template.Generate();

    if (res.HasErrors == true)
    {
        throw new Exception("Во время генерерации отчёта произошла ошибка. Проверьте корректность шаблона.");
    }

    using (var memory = new MemoryStream())
    {
        template.SaveAs(memory);
        memory.Position = 0;
        return memory.ToArray();
    }
}

    [DataContract(Name = nameof(MotivationExportByPeriodDto))]
    public class MotivationExportByPeriodDto
    {
        [DataMember]
        public string Rdc { get; set; }
        [DataMember]
        public long? EmployeeId { get; set; }
        [DataMember]
        public int? CrmId { get; set; }
        [DataMember]
        public string Position { get; set; }
        [DataMember]
        public string Fio { get; set; }
        [DataMember]
        public DateTime RepDate { get; set; }
        [DataMember]
        public decimal? Amount { get; set; }
        [DataMember]
        public string MotivationType { get; set; }
        [DataMember]
        public string MotivationDescription { get; set; }
        [DataMember]
        public long? DRDCId { get; set; }
        [DataMember]
        public string DRDCFio { get; set; }
        [DataMember]
        public long? PMId { get; set; }
        [DataMember]
        public string PMFio { get; set; }
        [DataMember]
        public long? TMId { get; set; }
        [DataMember]
        public string TMFio { get; set; }
        [DataMember]
        public long? SVId { get; set; }
        [DataMember]
        public string SVFio { get; set; }
        [DataMember]
        public int? Hour { get; set; }
        [DataMember]
        public string Message { get; set; }
    }

            Customer cust = new Customer();
            //cust.CustNo = 1;
            //cust.Company = "Company ABC";
            List<order> orders = new List<order>();
            for (int i = 0; i < 10; i++)
            {
                order myorder = new order();
                myorder.OrderNo = i + 1;
                //myorder.ShipToAddr1 = "AA " + i;
                myorder.Company = "ABC";
                myorder.PaymentMethod = "XYZ";
                myorder.ShipDate = DateTime.Now;
                myorder.ItemsTotal = 1;
                myorder.TaxRate = 5;
                myorder.AmountPaid = i;
                orders.Add(myorder);

            }
            cust.Orders = orders;
            template.AddVariable(new { orders = orders });
            template.Generate();
            template.SaveAs(outputFile);

        }
        catch(Exception ex)
        {

        }
    }

template.AddVariable("table", dataTable.Rows.Cast<DataRow>())