How to setup excel format when usng 2 binding list

[ldprenzy]

Hi, I'm trying to setup 2 diffent table report format but I cant seem to figure out how to setup the excel define names.

this is the excel format that im trying to achieve

Im using Zip items which working perfectly but I cant find a way to make it work on the excel file
public IEnumerable ZipItemsAndDiscounts(List items, List discounts)
{
var maxCount = Math.Max(items.Count, discounts.Count);

        for (var i = 0; i < maxCount; i++)
        {
            yield return new ItemAndDiscount
            {
                Item = (i < items.Count ? items[i] : null),
                Discount = (i < discounts.Count ? discounts[i] : null)
            };
        }
    }

here is the sample output base on the setup that ive tried
Sales_Order (5).xlsx
Sales_Order (4).xlsx

[CongThai-NTQSolution]

Hi @ldprenzy, you can try define names as this https://closedxml.io/ClosedXML.Report/docs/en/Flat-tables

[ldprenzy]

Hi @ldprenzy, you can try define names as this https://closedxml.io/ClosedXML.Report/docs/en/Flat-tables

Hi. Yes, I already tried that one. but the binding data only caters 1 table define name in a report format. in my case I have two separate table in 1 report format and I cant apply the same Define Name to the other table.

Well, Since Its not working on my end I have tried different approach instead of using XLTemplate I used XLWorkbook to cater the setup of my report format.

feel free to drop more suggestion. Thanks.