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_CellStyle()
{
this.extLstField = new CT_ExtensionList();
}
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_SingleXmlCell()
{
this.extLstField = new CT_ExtensionList();
this.xmlCellPrField = new CT_XmlCellPr();
}
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);
}
public CT_XmlPr()
{
this.extLstField = new CT_ExtensionList();
}
public CT_XmlColumnPr()
{
this.extLstField = new CT_ExtensionList();
this.denormalizedField = false;
}