I have an excel template and some C# code which is working to produce a table of data in a file using ClosedXML.Report
The bit that I can't get quite right is the heading above the data and the subtotals below along with delete, so I don't think I'm using the tags or directives correctly.
I can either get the heading above the data based on column1 and the subtotals below the data with the label column1 Total (which is fine) but then all of column1 is empty which I'd rather delete.
But when I try to use the <<Delete>> tag, column1 disappears and then causes an error with the subtotals.
I think it's possible to achieve what I need but I can't figure out how to get the directives/tags right.
Here's an image of the table from the excel template, I can provide more info and code if required.
excel table screenshot
| Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column14 | Column15 | Column16 | Column17 | Column18 | Column19 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| {{item.column1}} | {{item.column1}} | {{item.column1}} | {{item.column1}} | {{item.column1}} | {{item.column1}} | {{item.column1}} | {{item.column1}} | {{item.column1}} | {{item.column1}} | {{item.column1}} | {{item.column1}} | {{item.column1}} | {{item.column1}} | {{item.column1}} | {{item.column1}} | {{item.column1}} | {{item.column1}} | {{item.column1}} |
| <<group withheader PlaceToColumn=2 TotalLabel='Totals:'>> <<DisableGrandTotal>> | <<sum>> | <<sum>> | <<sum>> | <<sum>> |