Pivot Table Headers in .NET Excel Library

14 Aug 20261 minute to read

Yes. When a calculated field is added to a PivotTable, Microsoft Excel automatically prefixes the column header with Sum of before the original name. For example, a field named Profit becomes Sum of Profit. XlsIO follows the same behavior to remain consistent with Excel.