public XSSFPivotTable() : base() { pivotTableDefinition = new CT_PivotTableDefinition(); pivotCache = new XSSFPivotCache(); pivotCacheDefinition = new XSSFPivotCacheDefinition(); pivotCacheRecords = new XSSFPivotCacheRecords(); }
public void ReadFrom(Stream is1) { try { //XmlOptions options = new XmlOptions(DEFAULT_XML_OPTIONS); //Removing root element //options.LoadReplaceDocumentElement=(/*setter*/null); XmlDocument xmlDoc = ConvertStreamToXml(is1); pivotTableDefinition = CT_PivotTableDefinition.Parse(xmlDoc.DocumentElement, NamespaceManager); } catch (XmlException e) { throw new IOException(e.Message); } }
public void SetCTPivotTableDefinition(CT_PivotTableDefinition pivotTableDefinition) { this.pivotTableDefinition = pivotTableDefinition; }
public static CT_PivotTableDefinition Parse(XmlNode node, XmlNamespaceManager namespaceManager) { if (node == null) return null; CT_PivotTableDefinition ctObj = new CT_PivotTableDefinition(); ctObj.name = XmlHelper.ReadString(node.Attributes["name"]); if (node.Attributes["cacheId"] != null) ctObj.cacheId = XmlHelper.ReadUInt(node.Attributes["cacheId"]); if (node.Attributes["dataOnRows"] != null) ctObj.dataOnRows = XmlHelper.ReadBool(node.Attributes["dataOnRows"]); if (node.Attributes["dataPosition"] != null) ctObj.dataPosition = XmlHelper.ReadUInt(node.Attributes["dataPosition"]); if (node.Attributes["autoFormatId"] != null) ctObj.autoFormatId = XmlHelper.ReadUInt(node.Attributes["autoFormatId"]); if (node.Attributes["applyNumberFormats"] != null) ctObj.applyNumberFormats = XmlHelper.ReadBool(node.Attributes["applyNumberFormats"]); if (node.Attributes["applyBorderFormats"] != null) ctObj.applyBorderFormats = XmlHelper.ReadBool(node.Attributes["applyBorderFormats"]); if (node.Attributes["applyFontFormats"] != null) ctObj.applyFontFormats = XmlHelper.ReadBool(node.Attributes["applyFontFormats"]); if (node.Attributes["applyPatternFormats"] != null) ctObj.applyPatternFormats = XmlHelper.ReadBool(node.Attributes["applyPatternFormats"]); if (node.Attributes["applyAlignmentFormats"] != null) ctObj.applyAlignmentFormats = XmlHelper.ReadBool(node.Attributes["applyAlignmentFormats"]); if (node.Attributes["applyWidthHeightFormats"] != null) ctObj.applyWidthHeightFormats = XmlHelper.ReadBool(node.Attributes["applyWidthHeightFormats"]); ctObj.dataCaption = XmlHelper.ReadString(node.Attributes["dataCaption"]); ctObj.grandTotalCaption = XmlHelper.ReadString(node.Attributes["grandTotalCaption"]); ctObj.errorCaption = XmlHelper.ReadString(node.Attributes["errorCaption"]); if (node.Attributes["showError"] != null) ctObj.showError = XmlHelper.ReadBool(node.Attributes["showError"]); ctObj.missingCaption = XmlHelper.ReadString(node.Attributes["missingCaption"]); if (node.Attributes["showMissing"] != null) ctObj.showMissing = XmlHelper.ReadBool(node.Attributes["showMissing"]); ctObj.pageStyle = XmlHelper.ReadString(node.Attributes["pageStyle"]); ctObj.pivotTableStyle = XmlHelper.ReadString(node.Attributes["pivotTableStyle"]); ctObj.vacatedStyle = XmlHelper.ReadString(node.Attributes["vacatedStyle"]); ctObj.tag = XmlHelper.ReadString(node.Attributes["tag"]); if (node.Attributes["updatedVersion"] != null) ctObj.updatedVersion = XmlHelper.ReadByte(node.Attributes["updatedVersion"]); if (node.Attributes["minRefreshableVersion"] != null) ctObj.minRefreshableVersion = XmlHelper.ReadByte(node.Attributes["minRefreshableVersion"]); if (node.Attributes["asteriskTotals"] != null) ctObj.asteriskTotals = XmlHelper.ReadBool(node.Attributes["asteriskTotals"]); if (node.Attributes["showItems"] != null) ctObj.showItems = XmlHelper.ReadBool(node.Attributes["showItems"]); if (node.Attributes["editData"] != null) ctObj.editData = XmlHelper.ReadBool(node.Attributes["editData"]); if (node.Attributes["disableFieldList"] != null) ctObj.disableFieldList = XmlHelper.ReadBool(node.Attributes["disableFieldList"]); if (node.Attributes["showCalcMbrs"] != null) ctObj.showCalcMbrs = XmlHelper.ReadBool(node.Attributes["showCalcMbrs"]); if (node.Attributes["visualTotals"] != null) ctObj.visualTotals = XmlHelper.ReadBool(node.Attributes["visualTotals"]); if (node.Attributes["showMultipleLabel"] != null) ctObj.showMultipleLabel = XmlHelper.ReadBool(node.Attributes["showMultipleLabel"]); if (node.Attributes["showDataDropDown"] != null) ctObj.showDataDropDown = XmlHelper.ReadBool(node.Attributes["showDataDropDown"]); if (node.Attributes["showDrill"] != null) ctObj.showDrill = XmlHelper.ReadBool(node.Attributes["showDrill"]); if (node.Attributes["printDrill"] != null) ctObj.printDrill = XmlHelper.ReadBool(node.Attributes["printDrill"]); if (node.Attributes["showMemberPropertyTips"] != null) ctObj.showMemberPropertyTips = XmlHelper.ReadBool(node.Attributes["showMemberPropertyTips"]); if (node.Attributes["showDataTips"] != null) ctObj.showDataTips = XmlHelper.ReadBool(node.Attributes["showDataTips"]); if (node.Attributes["enableWizard"] != null) ctObj.enableWizard = XmlHelper.ReadBool(node.Attributes["enableWizard"]); if (node.Attributes["enableDrill"] != null) ctObj.enableDrill = XmlHelper.ReadBool(node.Attributes["enableDrill"]); if (node.Attributes["enableFieldProperties"] != null) ctObj.enableFieldProperties = XmlHelper.ReadBool(node.Attributes["enableFieldProperties"]); if (node.Attributes["preserveFormatting"] != null) ctObj.preserveFormatting = XmlHelper.ReadBool(node.Attributes["preserveFormatting"]); if (node.Attributes["useAutoFormatting"] != null) ctObj.useAutoFormatting = XmlHelper.ReadBool(node.Attributes["useAutoFormatting"]); if (node.Attributes["pageWrap"] != null) ctObj.pageWrap = XmlHelper.ReadUInt(node.Attributes["pageWrap"]); if (node.Attributes["pageOverThenDown"] != null) ctObj.pageOverThenDown = XmlHelper.ReadBool(node.Attributes["pageOverThenDown"]); if (node.Attributes["subtotalHiddenItems"] != null) ctObj.subtotalHiddenItems = XmlHelper.ReadBool(node.Attributes["subtotalHiddenItems"]); if (node.Attributes["rowGrandTotals"] != null) ctObj.rowGrandTotals = XmlHelper.ReadBool(node.Attributes["rowGrandTotals"]); if (node.Attributes["colGrandTotals"] != null) ctObj.colGrandTotals = XmlHelper.ReadBool(node.Attributes["colGrandTotals"]); if (node.Attributes["fieldPrintTitles"] != null) ctObj.fieldPrintTitles = XmlHelper.ReadBool(node.Attributes["fieldPrintTitles"]); if (node.Attributes["itemPrintTitles"] != null) ctObj.itemPrintTitles = XmlHelper.ReadBool(node.Attributes["itemPrintTitles"]); if (node.Attributes["mergeItem"] != null) ctObj.mergeItem = XmlHelper.ReadBool(node.Attributes["mergeItem"]); if (node.Attributes["showDropZones"] != null) ctObj.showDropZones = XmlHelper.ReadBool(node.Attributes["showDropZones"]); if (node.Attributes["createdVersion"] != null) ctObj.createdVersion = XmlHelper.ReadByte(node.Attributes["createdVersion"]); if (node.Attributes["indent"] != null) ctObj.indent = XmlHelper.ReadUInt(node.Attributes["indent"]); if (node.Attributes["showEmptyRow"] != null) ctObj.showEmptyRow = XmlHelper.ReadBool(node.Attributes["showEmptyRow"]); if (node.Attributes["showEmptyCol"] != null) ctObj.showEmptyCol = XmlHelper.ReadBool(node.Attributes["showEmptyCol"]); if (node.Attributes["showHeaders"] != null) ctObj.showHeaders = XmlHelper.ReadBool(node.Attributes["showHeaders"]); if (node.Attributes["compact"] != null) ctObj.compact = XmlHelper.ReadBool(node.Attributes["compact"]); if (node.Attributes["outline"] != null) ctObj.outline = XmlHelper.ReadBool(node.Attributes["outline"]); if (node.Attributes["outlineData"] != null) ctObj.outlineData = XmlHelper.ReadBool(node.Attributes["outlineData"]); if (node.Attributes["compactData"] != null) ctObj.compactData = XmlHelper.ReadBool(node.Attributes["compactData"]); if (node.Attributes["published"] != null) ctObj.published = XmlHelper.ReadBool(node.Attributes["published"]); if (node.Attributes["gridDropZones"] != null) ctObj.gridDropZones = XmlHelper.ReadBool(node.Attributes["gridDropZones"]); if (node.Attributes["immersive"] != null) ctObj.immersive = XmlHelper.ReadBool(node.Attributes["immersive"]); if (node.Attributes["multipleFieldFilters"] != null) ctObj.multipleFieldFilters = XmlHelper.ReadBool(node.Attributes["multipleFieldFilters"]); if (node.Attributes["chartFormat"] != null) ctObj.chartFormat = XmlHelper.ReadUInt(node.Attributes["chartFormat"]); ctObj.rowHeaderCaption = XmlHelper.ReadString(node.Attributes["rowHeaderCaption"]); ctObj.colHeaderCaption = XmlHelper.ReadString(node.Attributes["colHeaderCaption"]); if (node.Attributes["fieldListSortAscending"] != null) ctObj.fieldListSortAscending = XmlHelper.ReadBool(node.Attributes["fieldListSortAscending"]); if (node.Attributes["mdxSubqueries"] != null) ctObj.mdxSubqueries = XmlHelper.ReadBool(node.Attributes["mdxSubqueries"]); if (node.Attributes["customListSort"] != null) ctObj.customListSort = XmlHelper.ReadBool(node.Attributes["customListSort"]); foreach (XmlNode childNode in node.ChildNodes) { if (childNode.LocalName == "location") ctObj.location = CT_Location.Parse(childNode, namespaceManager); else if (childNode.LocalName == "pivotFields") ctObj.pivotFields = CT_PivotFields.Parse(childNode, namespaceManager); else if (childNode.LocalName == "rowFields") ctObj.rowFields = CT_RowFields.Parse(childNode, namespaceManager); else if (childNode.LocalName == "rowItems") ctObj.rowItems = CT_rowItems.Parse(childNode, namespaceManager); else if (childNode.LocalName == "colFields") ctObj.colFields = CT_ColFields.Parse(childNode, namespaceManager); else if (childNode.LocalName == "colItems") ctObj.colItems = CT_colItems.Parse(childNode, namespaceManager); else if (childNode.LocalName == "pageFields") ctObj.pageFields = CT_PageFields.Parse(childNode, namespaceManager); else if (childNode.LocalName == "dataFields") ctObj.dataFields = CT_DataFields.Parse(childNode, namespaceManager); else if (childNode.LocalName == "formats") ctObj.formats = CT_Formats.Parse(childNode, namespaceManager); else if (childNode.LocalName == "conditionalFormats") ctObj.conditionalFormats = CT_ConditionalFormats.Parse(childNode, namespaceManager); else if (childNode.LocalName == "chartFormats") ctObj.chartFormats = CT_ChartFormats.Parse(childNode, namespaceManager); else if (childNode.LocalName == "pivotHierarchies") ctObj.pivotHierarchies = CT_PivotHierarchies.Parse(childNode, namespaceManager); else if (childNode.LocalName == "pivotTableStyleInfo") ctObj.pivotTableStyleInfo = CT_PivotTableStyle.Parse(childNode, namespaceManager); else if (childNode.LocalName == "filters") ctObj.filters = CT_PivotFilters.Parse(childNode, namespaceManager); else if (childNode.LocalName == "rowHierarchiesUsage") ctObj.rowHierarchiesUsage = CT_RowHierarchiesUsage.Parse(childNode, namespaceManager); else if (childNode.LocalName == "colHierarchiesUsage") ctObj.colHierarchiesUsage = CT_ColHierarchiesUsage.Parse(childNode, namespaceManager); else if (childNode.LocalName == "extLst") ctObj.extLst = CT_ExtensionList.Parse(childNode, namespaceManager); } return ctObj; }