PageSetup

Overview

PageSetup is a class in Aspose.Cells for NET.

PageSetup.AddHorizontalPageBreak adds a page break after the specified row index.

Properties

Name	Type	Access	Description
`PaperSize`	`PaperSizeType`	Read/Write	Gets or sets the paper size used for printing
`Orientation`	`PageOrientationType`	Read/Write	Gets or sets the page orientation (portrait or landscape)
`FirstPageNumber`	`int?`	Read/Write	Gets or sets the number printed on the first page, nullable
`Scale`	`int?`	Read/Write	Gets or sets the print scaling percentage, nullable
`FitToPagesWide`	`int?`	Read/Write	Gets or sets the number of pages wide to fit when printing, nullable
`FitToPagesTall`	`int?`	Read/Write
`PrintArea`	`string`	Read/Write	Gets or sets the cell range that will be printed
`PrintTitleRows`	`string`	Read/Write	Gets or sets rows repeated at the top of each printed page
`PrintTitleColumns`	`string`	Read/Write	Gets or sets columns repeated at the left of each printed page
`LeftMargin`	`double`	Read/Write	Gets or sets the left margin in points
`RightMargin`	`double`	Read/Write	Gets or sets the right margin in points
`TopMargin`	`double`	Read/Write	Gets or sets the top margin in points
`BottomMargin`	`double`	Read/Write	Gets or sets the bottom margin in points
`HeaderMargin`	`double`	Read/Write	Gets or sets the header margin in points
`FooterMargin`	`double`	Read/Write	Gets or sets the footer margin in points
`LeftMarginInch`	`double`	Read/Write	Gets or sets the left margin in inches
`RightMarginInch`	`double`	Read/Write	Gets or sets the right margin in inches
`TopMarginInch`	`double`	Read/Write	Gets or sets the top margin in inches
`BottomMarginInch`	`double`	Read/Write	Gets or sets the bottom margin in inches
`HeaderMarginInch`	`double`	Read/Write	Gets or sets the header margin in inches
`FooterMarginInch`	`double`	Read/Write	Gets or sets the footer margin in inches
`LeftHeader`	`string`	Read/Write	Gets or sets the text displayed in the left section of the header
`CenterHeader`	`string`	Read/Write
`RightHeader`	`string`	Read/Write	Gets or sets text displayed in the right section of the page header
`LeftFooter`	`string`	Read/Write	Gets or sets text displayed in the left section of the page footer
`CenterFooter`	`string`	Read/Write	Gets or sets the text displayed in the center section of the footer
`RightFooter`	`string`	Read/Write
`PrintGridlines`	`bool`	Read/Write	Gets or sets whether gridlines are printed on the page
`PrintHeadings`	`bool`	Read/Write	Gets or sets whether row and column headings are printed
`CenterHorizontally`	`bool`	Read/Write	Gets or sets whether the sheet is centered horizontally when printed
`CenterVertically`	`bool`	Read/Write
`HorizontalPageBreaks`	`IReadOnlyList<int>`	Read
`VerticalPageBreaks`	`IReadOnlyList<int>`	Read

Methods

Signature	Description
`AddHorizontalPageBreak(rowIndex: int)`	Adds a page break after the specified row index
`AddVerticalPageBreak(columnIndex: int)`	Adds a page break after the specified column index
`ClearHorizontalPageBreaks()`	Removes all horizontal page breaks
`ClearVerticalPageBreaks()`	Removes all vertical page breaks