public XSSFPrintSetup(CT_Worksheet worksheet)
{
this.ctWorksheet = worksheet;
this.pageSetup = !this.ctWorksheet.IsSetPageSetup() ? this.ctWorksheet.AddNewPageSetup() : this.ctWorksheet.pageSetup;
if (this.ctWorksheet.IsSetPageMargins())
{
this.pageMargins = this.ctWorksheet.pageMargins;
}
else
{
this.pageMargins = this.ctWorksheet.AddNewPageMargins();
}
}
public void TestSetGetHeaderFooterMargin()
{
CT_Worksheet worksheet = new CT_Worksheet();
CT_PageMargins pMargins = worksheet.AddNewPageMargins();
pMargins.header = (1.5);
pMargins.footer = (2);
XSSFPrintSetup printSetup = new XSSFPrintSetup(worksheet);
Assert.AreEqual(1.5, printSetup.HeaderMargin, 0.0);
Assert.AreEqual(2.0, printSetup.FooterMargin, 0.0);
printSetup.HeaderMargin = (5);
printSetup.FooterMargin = (3.5);
Assert.AreEqual(5.0, pMargins.header, 0.0);
Assert.AreEqual(3.5, pMargins.footer, 0.0);
}
private void CreateChart()
{
this.chartSpace = new CT_ChartSpace();
this.chart = this.chartSpace.AddNewChart();
this.chart.AddNewPlotArea().AddNewLayout();
this.chart.AddNewPlotVisOnly().val = 1;
CT_PrintSettings ctPrintSettings = this.chartSpace.AddNewPrintSettings();
ctPrintSettings.AddNewHeaderFooter();
CT_PageMargins ctPageMargins = ctPrintSettings.AddNewPageMargins();
ctPageMargins.b = 0.75;
ctPageMargins.l = 0.7;
ctPageMargins.r = 0.7;
ctPageMargins.t = 0.75;
ctPageMargins.header = 0.3;
ctPageMargins.footer = 0.3;
ctPrintSettings.AddNewPageSetup();
}
/**
* Construct a new CTChartSpace bean.
* By default, it's just an empty placeholder for chart objects.
*
* @return a new CTChartSpace bean
*/
private void CreateChart()
{
chartSpaceDocument = new ChartSpaceDocument();
chart = chartSpaceDocument.GetChartSpace().AddNewChart();
CT_PlotArea plotArea = chart.AddNewPlotArea();
plotArea.AddNewLayout();
chart.AddNewPlotVisOnly().val = 1;
CT_PrintSettings printSettings = chartSpaceDocument.GetChartSpace().AddNewPrintSettings();
printSettings.AddNewHeaderFooter();
CT_PageMargins pageMargins = printSettings.AddNewPageMargins();
pageMargins.b = 0.75;
pageMargins.l = 0.70;
pageMargins.r = 0.70;
pageMargins.t = 0.75;
pageMargins.header = 0.30;
pageMargins.footer = 0.30;
printSettings.AddNewPageSetup();
}
public CT_PageMargins AddNewPageMargins()
{
this.pageMarginsField = new CT_PageMargins();
return(this.pageMarginsField);
}
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 void WritePageMargins(CT_PageMargins margins)
{
this.WriteStandaloneTag(margins, StreamSheetSection.PageMargins, CT_Worksheet.PageMarginsElementName);
}
