public CT_Metadata() { this.extLstField = new CT_ExtensionList(); this.valueMetadataField = new CT_MetadataBlocks(); this.cellMetadataField = new CT_MetadataBlocks(); this.futureMetadataField = new List<CT_FutureMetadata>(); this.mdxMetadataField = new CT_MdxMetadata(); this.metadataStringsField = new CT_MetadataStrings(); this.metadataTypesField = new CT_MetadataTypes(); }
//public CT_Cell() //{ // this.extLstField = new CT_ExtensionList(); // //this.isField = new CT_Rst(); // //this.fField = new CT_CellFormula(); // this.sField = (uint)(0); // this.tField = ST_CellType.n; // this.cmField = ((uint)(0)); // this.vmField = ((uint)(0)); // this.phField = false; //} public void Set(CT_Cell cell) { fField = cell.fField; vField = cell.vField; isField = cell.isField; extLstField = cell.extLstField; rField = cell.rField; sField = cell.sField; tField = cell.tField; cmField = cell.cmField; vmField = cell.vmField; phField = cell.phField; }
public CT_CellStyle() { this.extLstField = new CT_ExtensionList(); }
public CT_IgnoredErrors() { this.extLstField = new CT_ExtensionList(); this.ignoredErrorField = new List<CT_IgnoredError>(); }
public CT_FutureMetadataBlock() { this.extLstField = new CT_ExtensionList(); }
public CT_XmlColumnPr() { this.extLstField = new CT_ExtensionList(); this.denormalizedField = false; }
public CT_SingleXmlCell() { this.extLstField = new CT_ExtensionList(); this.xmlCellPrField = new CT_XmlCellPr(); }
private List<CT_Extension> extField = new List<CT_Extension>(); // 0..* public CT_ExtensionList Copy() { CT_ExtensionList obj = new CT_ExtensionList(); obj.ext = new List<CT_Extension>(this.ext); return obj; }
public CT_RevisionCellChange() { this.extLstField = new CT_ExtensionList(); this.ndxfField = new CT_Dxf(); this.odxfField = new CT_Dxf(); this.ncField = new CT_Cell(); this.ocField = new CT_Cell(); this.uaField = false; this.raField = false; this.odxf1Field = false; this.xfDxfField = false; this.sField = false; this.dxfField = false; this.quotePrefixField = false; this.oldQuotePrefixField = false; this.phField = false; this.oldPhField = false; this.endOfListFormulaUpdateField = false; }
public CT_RevisionHeader() { this.extLstField = new CT_ExtensionList(); this.reviewedListField = new CT_ReviewedRevisions(); this.sheetIdMapField = new CT_SheetIdMap(); }
public CT_RevisionSheetRename() { this.extLstField = new CT_ExtensionList(); this.uaField = false; this.raField = false; }
public CT_RevisionFormatting() { this.sqrefField = new List<string>(); this.extLstField = new CT_ExtensionList(); this.dxfField = new CT_Dxf(); this.xfDxfField = false; this.sField = false; }
public CT_RevisionDefinedName() { this.extLstField = new CT_ExtensionList(); this.uaField = false; this.raField = false; this.customViewField = false; this.functionField = false; this.oldFunctionField = false; this.hiddenField = false; this.oldHiddenField = false; }
public CT_XmlPr() { this.extLstField = new CT_ExtensionList(); }
public CT_Macrosheet() { this.extLstField = new CT_ExtensionList(); this.oleObjectsField = new List<CT_OleObject>(); this.pictureField = new CT_SheetBackgroundPicture(); this.legacyDrawingHFField = new CT_LegacyDrawing(); this.legacyDrawingField = new CT_LegacyDrawing(); this.drawingField = new CT_Drawing(); this.customPropertiesField = new List<CT_CustomProperty>(); this.colBreaksField = new CT_PageBreak(); this.rowBreaksField = new CT_PageBreak(); this.headerFooterField = new CT_HeaderFooter(); this.pageSetupField = new CT_PageSetup(); this.pageMarginsField = new CT_PageMargins(); this.printOptionsField = new CT_PrintOptions(); this.conditionalFormattingField = new List<CT_ConditionalFormatting>(); this.phoneticPrField = new CT_PhoneticPr(); this.customSheetViewsField = new List<CT_CustomSheetView>(); this.dataConsolidateField = new CT_DataConsolidate(); this.sortStateField = new CT_SortState(); this.autoFilterField = new CT_AutoFilter(); this.sheetProtectionField = new CT_SheetProtection(); this.sheetDataField = new List<CT_Row>(); this.colsField = new List<CT_Col>(); this.sheetFormatPrField = new CT_SheetFormatPr(); this.sheetViewsField = new CT_SheetViews(); this.dimensionField = new CT_SheetDimension(); this.sheetPrField = new CT_SheetPr(); }
//public CT_ConditionalFormatting Copy() //{ // throw new NotImplementedException(); //} public void Set(CT_ConditionalFormatting obj) { this.cfRuleField = obj.cfRuleField; this.extLstField = obj.extLstField; this.pivotField = obj.pivotField; this.sqrefField = obj.sqrefField; }
public CT_SharedUser() { this.extLstField = new CT_ExtensionList(); }
public CT_PivotCacheDefinition() { this.extLstField = new CT_ExtensionList(); this.mapsField = new CT_MeasureDimensionMaps(); this.measureGroupsField = new CT_MeasureGroups(); this.dimensionsField = new CT_Dimensions(); this.calculatedMembersField = new CT_CalculatedMembers(); this.calculatedItemsField = new CT_CalculatedItems(); this.tupleCacheField = new CT_TupleCache(); this.kpisField = new CT_PCDKPIs(); this.cacheHierarchiesField = new CT_CacheHierarchies(); this.cacheFieldsField = new CT_CacheFields(); this.cacheSourceField = new CT_CacheSource(); this.invalidField = false; this.saveDataField = true; this.refreshOnLoadField = false; this.optimizeMemoryField = false; this.enableRefreshField = true; this.backgroundQueryField = false; this.createdVersionField = ((byte)(0)); this.refreshedVersionField = ((byte)(0)); this.minRefreshableVersionField = ((byte)(0)); this.upgradeOnRefreshField = false; this.tupleCache1Field = false; this.supportSubqueryField = false; this.supportAdvancedDrillField = false; }
public CT_PivotCacheRecords() { this.extLstField = new CT_ExtensionList(); this.rField = new List <object>(); }
public CT_CacheField() { this.extLstField = new CT_ExtensionList(); this.mpMapField = new List<CT_X>(); this.fieldGroupField = new CT_FieldGroup(); this.sharedItemsField = new CT_SharedItems(); this.serverFieldField = false; this.uniqueListField = true; this.sqlTypeField = 0; this.hierarchyField = 0; this.levelField = ((uint)(0)); this.databaseFieldField = true; this.memberPropertyFieldField = false; }
public static CT_Worksheet Parse(XmlNode node, XmlNamespaceManager namespaceManager) { if (node == null) { return(null); } CT_Worksheet ctObj = new CT_Worksheet(); ctObj.cols = new List <CT_Cols>(); ctObj.conditionalFormatting = new List <CT_ConditionalFormatting>(); foreach (XmlNode childNode in node.ChildNodes) { if (childNode.LocalName == "sheetPr") { ctObj.sheetPr = CT_SheetPr.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "dimension") { ctObj.dimension = CT_SheetDimension.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "sheetViews") { ctObj.sheetViews = CT_SheetViews.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "sheetFormatPr") { ctObj.sheetFormatPr = CT_SheetFormatPr.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "sheetData") { ctObj.sheetData = CT_SheetData.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "sheetCalcPr") { ctObj.sheetCalcPr = CT_SheetCalcPr.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "sheetProtection") { ctObj.sheetProtection = CT_SheetProtection.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "protectedRanges") { ctObj.protectedRanges = CT_ProtectedRanges.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "scenarios") { ctObj.scenarios = CT_Scenarios.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "autoFilter") { ctObj.autoFilter = CT_AutoFilter.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "sortState") { ctObj.sortState = CT_SortState.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "dataConsolidate") { ctObj.dataConsolidate = CT_DataConsolidate.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "customSheetViews") { ctObj.customSheetViews = CT_CustomSheetViews.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "mergeCells") { ctObj.mergeCells = CT_MergeCells.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "phoneticPr") { ctObj.phoneticPr = CT_PhoneticPr.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "dataValidations") { ctObj.dataValidations = CT_DataValidations.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "hyperlinks") { ctObj.hyperlinks = CT_Hyperlinks.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "printOptions") { ctObj.printOptions = CT_PrintOptions.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "pageMargins") { ctObj.pageMargins = CT_PageMargins.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "pageSetup") { ctObj.pageSetup = CT_PageSetup.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "headerFooter") { ctObj.headerFooter = CT_HeaderFooter.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "rowBreaks") { ctObj.rowBreaks = CT_PageBreak.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "colBreaks") { ctObj.colBreaks = CT_PageBreak.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "customProperties") { ctObj.customProperties = CT_CustomProperties.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "cellWatches") { ctObj.cellWatches = CT_CellWatches.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "ignoredErrors") { ctObj.ignoredErrors = CT_IgnoredErrors.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "smartTags") { ctObj.smartTags = CT_CellSmartTags.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "drawing") { ctObj.drawing = CT_Drawing.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "legacyDrawing") { ctObj.legacyDrawing = CT_LegacyDrawing.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "legacyDrawingHF") { ctObj.legacyDrawingHF = CT_LegacyDrawing.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "picture") { ctObj.picture = CT_SheetBackgroundPicture.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "oleObjects") { ctObj.oleObjects = CT_OleObjects.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "controls") { ctObj.controls = CT_Controls.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "webPublishItems") { ctObj.webPublishItems = CT_WebPublishItems.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "tableParts") { ctObj.tableParts = CT_TableParts.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "extLst") { ctObj.extLst = CT_ExtensionList.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "cols") { ctObj.cols.Add(CT_Cols.Parse(childNode, namespaceManager)); } else if (childNode.LocalName == "conditionalFormatting") { ctObj.conditionalFormatting.Add(CT_ConditionalFormatting.Parse(childNode, namespaceManager)); } } return(ctObj); }
public CT_GroupLevel() { this.extLstField = new CT_ExtensionList(); this.groupsField = new CT_Groups(); this.userField = false; this.customRollUpField = false; }
public CT_FutureMetadata() { this.extLstField = new CT_ExtensionList(); this.bkField = new List <CT_FutureMetadataBlock>(); this.countField = ((uint)(0)); }
public CT_CacheHierarchy() { this.extLstField = new CT_ExtensionList(); this.groupLevelsField = new CT_GroupLevels(); this.fieldsUsageField = new CT_FieldsUsage(); this.measureField = false; this.setField = false; this.iconSetField = 0; this.attributeField = false; this.timeField = false; this.keyAttributeField = false; this.measuresField = false; this.oneFieldField = false; this.hiddenField = false; }
public CT_CfRule() { this.extLstField = new CT_ExtensionList(); this.iconSetField = new CT_IconSet(); this.dataBarField = new CT_DataBar(); this.colorScaleField = new CT_ColorScale(); this.formulaField = new List<string>(); this.stopIfTrueField = false; this.aboveAverageField = true; this.percentField = false; this.bottomField = false; this.equalAverageField = false; }
public CT_TupleCache() { this.extLstField = new CT_ExtensionList(); this.serverFormatsField = new CT_ServerFormats(); this.queryCacheField = new CT_QueryCache(); this.setsField = new CT_Sets(); this.entriesField = new CT_PCDSDTCEntries(); }
public CT_ChartsheetView() { this.extLstField = new CT_ExtensionList(); this.tabSelectedField = false; this.zoomScaleField = ((uint)(100)); this.zoomToFitField = false; }
public CT_CalculatedItem() { this.extLstField = new CT_ExtensionList(); this.pivotAreaField = new CT_PivotArea(); }
public CT_Cfvo() { this.extLstField = new CT_ExtensionList(); this.gteField = true; }
public CT_CalculatedMember() { this.extLstField = new CT_ExtensionList(); this.solveOrderField = 0; this.setField = false; }
public CT_PivotAreaReference() { this.extLstField = new CT_ExtensionList(); this.xField = new List<CT_Index>(); this.selectedField = true; this.byPositionField = false; this.relativeField = false; this.defaultSubtotalField = false; this.sumSubtotalField = false; this.countASubtotalField = false; this.avgSubtotalField = false; this.maxSubtotalField = false; this.minSubtotalField = false; this.productSubtotalField = false; this.countSubtotalField = false; this.stdDevSubtotalField = false; this.stdDevPSubtotalField = false; this.varSubtotalField = false; this.varPSubtotalField = false; }
public void Set(CT_Row row) { cField = row.cField; extLstField = row.extLstField; rField = row.rField; spansField = row.spansField; sField = row.sField; customFormatField = row.customFormatField; htField = row.htField; hiddenField = row.hiddenField; customHeightField = row.customHeightField; outlineLevelField = row.outlineLevelField; collapsedField = row.collapsedField; thickTopField = row.thickTopField; thickBotField = row.thickBotField; phField = row.phField; }
public CT_ChartsheetViews() { this.extLstField = new CT_ExtensionList(); this.sheetViewField = new List<CT_ChartsheetView>(); }
public static CT_Workbook Parse(XmlNode node, XmlNamespaceManager namespaceManager) { if (node == null) { return(null); } CT_Workbook ctObj = new CT_Workbook(); ctObj.fileRecoveryPr = new List <CT_FileRecoveryPr>(); foreach (XmlNode childNode in node.ChildNodes) { if (childNode.LocalName == "fileVersion") { ctObj.fileVersion = CT_FileVersion.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "fileSharing") { ctObj.fileSharing = CT_FileSharing.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "workbookPr") { ctObj.workbookPr = CT_WorkbookPr.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "workbookProtection") { ctObj.workbookProtection = CT_WorkbookProtection.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "bookViews") { ctObj.bookViews = CT_BookViews.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "sheets") { ctObj.sheets = CT_Sheets.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "functionGroups") { ctObj.functionGroups = CT_FunctionGroups.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "externalReferences") { ctObj.externalReferences = CT_ExternalReferences.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "definedNames") { ctObj.definedNames = CT_DefinedNames.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "calcPr") { ctObj.calcPr = CT_CalcPr.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "oleSize") { ctObj.oleSize = CT_OleSize.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "customWorkbookViews") { ctObj.customWorkbookViews = CT_CustomWorkbookViews.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "pivotCaches") { ctObj.pivotCaches = CT_PivotCaches.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "smartTagPr") { ctObj.smartTagPr = CT_SmartTagPr.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "smartTagTypes") { ctObj.smartTagTypes = CT_SmartTagTypes.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "webPublishing") { ctObj.webPublishing = CT_WebPublishing.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "webPublishObjects") { ctObj.webPublishObjects = CT_WebPublishObjects.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "extLst") { ctObj.extLst = CT_ExtensionList.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "fileRecoveryPr") { ctObj.fileRecoveryPr.Add(CT_FileRecoveryPr.Parse(childNode, namespaceManager)); } } return(ctObj); }
public static CT_ExtensionList Parse(XmlNode node, XmlNamespaceManager namespaceManager) { if (node == null) return null; CT_ExtensionList ctObj = new CT_ExtensionList(); ctObj.ext = new List<CT_Extension>(); foreach (XmlNode childNode in node.ChildNodes) { if (childNode.LocalName == "ext") ctObj.ext.Add(CT_Extension.Parse(childNode, namespaceManager)); } return ctObj; }
public static CT_Table Parse(XmlNode node, XmlNamespaceManager namespaceManager) { if (node == null) { return(null); } CT_Table ctObj = new CT_Table(); if (node.Attributes["id"] != null) { ctObj.id = XmlHelper.ReadUInt(node.Attributes["id"]); } ctObj.name = XmlHelper.ReadString(node.Attributes["name"]); ctObj.displayName = XmlHelper.ReadString(node.Attributes["displayName"]); ctObj.comment = XmlHelper.ReadString(node.Attributes["comment"]); ctObj.@ref = XmlHelper.ReadString(node.Attributes["ref"]); if (node.Attributes["tableType"] != null) { ctObj.tableType = (ST_TableType)Enum.Parse(typeof(ST_TableType), node.Attributes["tableType"].Value); } if (node.Attributes["headerRowCount"] != null) { ctObj.headerRowCount = XmlHelper.ReadUInt(node.Attributes["headerRowCount"]); } if (node.Attributes["insertRow"] != null) { ctObj.insertRow = XmlHelper.ReadBool(node.Attributes["insertRow"]); } if (node.Attributes["insertRowShift"] != null) { ctObj.insertRowShift = XmlHelper.ReadBool(node.Attributes["insertRowShift"]); } if (node.Attributes["totalsRowCount"] != null) { ctObj.totalsRowCount = XmlHelper.ReadUInt(node.Attributes["totalsRowCount"]); } if (node.Attributes["totalsRowShown"] != null) { ctObj.totalsRowShown = XmlHelper.ReadBool(node.Attributes["totalsRowShown"]); } if (node.Attributes["published"] != null) { ctObj.published = XmlHelper.ReadBool(node.Attributes["published"]); } if (node.Attributes["headerRowDxfId"] != null) { ctObj.headerRowDxfId = XmlHelper.ReadUInt(node.Attributes["headerRowDxfId"]); } if (node.Attributes["dataDxfId"] != null) { ctObj.dataDxfId = XmlHelper.ReadUInt(node.Attributes["dataDxfId"]); } if (node.Attributes["totalsRowDxfId"] != null) { ctObj.totalsRowDxfId = XmlHelper.ReadUInt(node.Attributes["totalsRowDxfId"]); } if (node.Attributes["headerRowBorderDxfId"] != null) { ctObj.headerRowBorderDxfId = XmlHelper.ReadUInt(node.Attributes["headerRowBorderDxfId"]); } if (node.Attributes["tableBorderDxfId"] != null) { ctObj.tableBorderDxfId = XmlHelper.ReadUInt(node.Attributes["tableBorderDxfId"]); } if (node.Attributes["totalsRowBorderDxfId"] != null) { ctObj.totalsRowBorderDxfId = XmlHelper.ReadUInt(node.Attributes["totalsRowBorderDxfId"]); } ctObj.headerRowCellStyle = XmlHelper.ReadString(node.Attributes["headerRowCellStyle"]); ctObj.dataCellStyle = XmlHelper.ReadString(node.Attributes["dataCellStyle"]); ctObj.totalsRowCellStyle = XmlHelper.ReadString(node.Attributes["totalsRowCellStyle"]); if (node.Attributes["connectionId"] != null) { ctObj.connectionId = XmlHelper.ReadUInt(node.Attributes["connectionId"]); } foreach (XmlNode childNode in node.ChildNodes) { if (childNode.LocalName == "autoFilter") { ctObj.autoFilter = CT_AutoFilter.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "sortState") { ctObj.sortState = CT_SortState.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "tableColumns") { ctObj.tableColumns = CT_TableColumns.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "tableStyleInfo") { ctObj.tableStyleInfo = CT_TableStyleInfo.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "extLst") { ctObj.extLst = CT_ExtensionList.Parse(childNode, namespaceManager); } } return(ctObj); }