I am generating invoices from a SQL Table into Gembox Spreadsheet.
I formatted all the data in the sheet as a table, and I am wanting to add a summary of 2 of the columns in the table. It’s always the same two columns, AA and AB which are the last 2 columns in the sheet.
How do I add a summary line, only summing those 2 columns and adding a row a text of Total? I haven’t seen anything in the examples, or anything online that would help guide me. If there is an example, please point me in that direction.
I tried adding the below, but that’s as far as I can figure out.
var table = xlWorksheet.Tables.Add(oDT.TableName.ToString(), cellRng, true); table.BuiltInStyle = BuiltInTableStyleName.TableStyleMedium2; table.HasTotalsRow = true; table.StyleOptions = TableStyleOptions.BandedRows;