ClosedXML.Report icon indicating copy to clipboard operation
ClosedXML.Report copied to clipboard

Cannot use excel tables (formatted, with design) defined on worksheet for templating

Open hidegh opened this issue 6 months ago • 1 comments

are only named datasets supported or should the usual tables defined on a worksheet work? using tables would be cool - adds styling (odd/even row, header, filtering...)

-- same setup 2x2 data range (although I don't like that the service row is mandatory)

same range once defined as named dataset another time as a table with header (but the header row isn't part of the dataset)

yes, i have both Children and ChildrenTest List<Child> object to use...

Image Image Image

hidegh avatar Aug 05 '25 17:08 hidegh

My workaround is simple:

  • make the excel table template have 2 data rows
  • name the table
  • then create a named region for the 2 data-rows, but extend it one column to the right...

hidegh avatar Aug 21 '25 13:08 hidegh