I display Total Row like this:
worksheet.ListObjects[0].ShowTotals = true;
worksheet.ListObjects[0].ListColumns[0].TotalsCalculation = TotalsCalculation.None;
worksheet.ListObjects[0].ListColumns[1].TotalsCalculation = TotalsCalculation.Sum;
However, the first cell in this row contains the word ‘total’ and I cannot remove it:
worksheet.Cells[6, 0].PutValue(String.Empty);
How can I remove this word?
It also applies bold to this cell which I cannot overwrite:
Style firstCellStyle = workbook.CreateStyle();
firstCellStyle.Font.Size = 9;
firstCellStyle.Font.Color = StyleHelper.ColorRed;
firstCellStyle.Font.IsBold = false;
int index = tableStyle.TableStyleElements.Add(TableStyleElementType.FirstTotalCell);
tableStyle.TableStyleElements[index].SetElementStyle(firstCellStyle);