public XSSFPrintSetup(CT_Worksheet worksheet) { this.ctWorksheet = worksheet; if (ctWorksheet.IsSetPageSetup()) { this.pageSetup = ctWorksheet.pageSetup; } else { this.pageSetup = ctWorksheet.AddNewPageSetup(); } if (ctWorksheet.IsSetPageMargins()) { this.pageMargins = ctWorksheet.pageMargins; } else { this.pageMargins = ctWorksheet.AddNewPageMargins(); } }
public CT_PageSetup AddNewPageSetup() { this.pageSetupField = new CT_PageSetup(); return this.pageSetupField; }
public static CT_PageSetup Parse(XmlNode node, XmlNamespaceManager namespaceManager) { if (node == null) return null; CT_PageSetup ctObj = new CT_PageSetup(); ctObj.paperSize = XmlHelper.ReadUInt(node.Attributes["paperSize"]); ctObj.scale = XmlHelper.ReadUInt(node.Attributes["scale"]); ctObj.firstPageNumber = XmlHelper.ReadUInt(node.Attributes["firstPageNumber"]); ctObj.fitToWidth = XmlHelper.ReadUInt(node.Attributes["fitToWidth"]); ctObj.fitToHeight = XmlHelper.ReadUInt(node.Attributes["fitToHeight"]); if (node.Attributes["pageOrder"] != null) ctObj.pageOrder = (ST_PageOrder)Enum.Parse(typeof(ST_PageOrder), node.Attributes["pageOrder"].Value); if (node.Attributes["orientation"] != null) ctObj.orientation = (ST_Orientation)Enum.Parse(typeof(ST_Orientation), node.Attributes["orientation"].Value); if (node.Attributes["usePrinterDefaults"] == null) ctObj.usePrinterDefaults = true; else ctObj.usePrinterDefaults = XmlHelper.ReadBool(node.Attributes["usePrinterDefaults"]); ctObj.blackAndWhite = XmlHelper.ReadBool(node.Attributes["blackAndWhite"]); ctObj.draft = XmlHelper.ReadBool(node.Attributes["draft"]); if (node.Attributes["cellComments"] != null) ctObj.cellComments = (ST_CellComments)Enum.Parse(typeof(ST_CellComments), node.Attributes["cellComments"].Value); ctObj.useFirstPageNumber = XmlHelper.ReadBool(node.Attributes["useFirstPageNumber"]); if (node.Attributes["errors"] != null) ctObj.errors = (ST_PrintError)Enum.Parse(typeof(ST_PrintError), node.Attributes["errors"].Value); ctObj.horizontalDpi = XmlHelper.ReadUInt(node.Attributes["horizontalDpi"]); ctObj.verticalDpi = XmlHelper.ReadUInt(node.Attributes["verticalDpi"]); ctObj.copies = XmlHelper.ReadUInt(node.Attributes["copies"]); ctObj.id = XmlHelper.ReadString(node.Attributes["id", PackageNamespaces.SCHEMA_RELATIONSHIPS]); return ctObj; }
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(); }