C# (CSharp) NPOI.XSSF.UserModel XSSFPivotTable.AddColumnLabel Exemples

Exemple #1

        public void TestAddDataColumnWithOffsetData()
        {
            offsetPivotTable.AddColumnLabel(DataConsolidateFunction.SUM, 1);
            Assert.AreEqual(CellType.Numeric, offsetOuterCell.CellType);

            offsetPivotTable.AddColumnLabel(DataConsolidateFunction.SUM, 0);
        }

Exemple #2

        public void TestAddOneColumnLabelToPivotTableDoesNotCreateColField()
        {
            int columnIndex = 0;

            pivotTable.AddColumnLabel(DataConsolidateFunction.SUM, columnIndex);
            CT_PivotTableDefinition defintion = pivotTable.GetCTPivotTableDefinition();

            Assert.AreEqual(defintion.colFields, null);
        }