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

AppendField() private method

private AppendField ( XmlNode rowsNode, int index, string fieldNodeText, string indexAttrText ) : XmlElement
rowsNode	System.Xml.XmlNode
index	int
fieldNodeText	string
indexAttrText	string
return	System.Xml.XmlElement

Example #1

        /// <summary>
        /// Add a new datafield
        /// </summary>
        /// <param name="field">The field</param>
        /// <returns>The new datafield</returns>
        public ExcelPivotTableDataField Add(ExcelPivotTableField field)
        {
            var dataFieldsNode = field.TopNode.SelectSingleNode("../../d:dataFields", field.NameSpaceManager);

            if (dataFieldsNode == null)
            {
                _table.CreateNode("d:dataFields");
                dataFieldsNode = field.TopNode.SelectSingleNode("../../d:dataFields", field.NameSpaceManager);
            }

            XmlElement node = field.AppendField(dataFieldsNode, field.Index, "dataField", "fld");

            field.SetXmlNodeBool("@dataField", true, false);

            var dataField = new ExcelPivotTableDataField(field.NameSpaceManager, node, field);

            _list.Add(dataField);
            return(dataField);
        }