C# (CSharp) OfficeOpenXml.Table.PivotTable ExcelPivotTableField.LoadItems Examples

Example #1

File: ExcelPivotTable.cs Project: peterpavles/EPPlus-1

        private void LoadFields()
        {
            int index          = 0;
            var pivotFieldNode = TopNode.SelectSingleNode("d:pivotFields", NameSpaceManager);

            //Add fields.
            foreach (XmlElement fieldElem in pivotFieldNode.SelectNodes("d:pivotField", NameSpaceManager))
            {
                var fld = new ExcelPivotTableField(NameSpaceManager, fieldElem, this, index, index);
                fld._cacheField = CacheDefinition._cacheReference.Fields[index++];
                fld.LoadItems();
                Fields.AddInternal(fld);
            }
        }