NativeExcel2 for .Net Developer's Reference

IPageSetupProperties

The properties of the IPageSetup interface are listed below. For a complete list of IPageSetup interface members, see the IPageSetup Members topic.

Public Instance Properties

BlackAndWhite Gets or sets a value that indicates whether the sheet will be printed in black and white.
BottomMargin Gets or sets the size of the bottom margin, in inches.
CenterFooter Returns or sets the center part of the footer.
CenterHeader Returns or sets the center part of the header.
CenterHorizontally Gets or sets a value that indicates whether the sheet is centered horizontally.
CenterVertically Gets or sets a value that indicates whether the sheet is centered vertically.
Draft Gets or sets a value that indicates whether the sheet will be printed with or without graphics.
FitToPages Gets or sets a value that indicates whether the worksheet is scaled for printing using Zoom property or FitToPagesWide and FitToPagesTall properties.
FitToPagesTall Gets or sets the number of pages tall the worksheet will be scaled to when it's printed.
FitToPagesWide Gets or sets the number of pages wide the worksheet will be scaled to when it's printed.
FooterMargin Gets or sets the distance from the bottom of the page to the footer, in inches.
HeaderMargin Gets or sets the distance from the top of the page to the header, in inches.
LeftFooter Returns or sets the left part of the footer.
LeftHeader Returns or sets the left part of the header.
LeftMargin Gets or sets the size of the left margin, in inches.
Order Gets or sets the order in which worksheet pages are numbered.
Orientation Portrait or landscape printing mode.
PaperSize Gets or sets the size of the paper.
PrintArea Gets or sets the range to be printed, as a string using A1-style references.
PrintAreaDefined Gets a value that indicates whether the PrintArea is defined.
PrintGridLines Gets or sets a value that indicates whether the cell gridlines are printed on the page.
PrintHeadings Gets or sets a value that indicates whether the row and column headings are printed with this page.
PrintNotes Gets or sets a value that indicates whether the notes will be printed as end notes with the sheet.
PrintTitleColumns Gets or sets the columns that contain the cells to be repeated on the left side of each page, as a string in A1-style notation.
PrintTitleColumnsDefined Gets a value that indicates whether the PrintTitleColumns is defined.
PrintTitleRows Returns or sets the rows that contain the cells to be repeated at the top of each page, as a string in A1-style notation.
PrintTitleRowsDefined Gets a value that indicates whether the PrintTitleRows is defined.
RightFooter Returns or sets the right part of the footer.
RightHeader Returns or sets the right part of the header.
RightMargin Gets or sets the size of the right margin, in inches.
TopMargin Gets or sets the size of the top margin, in inches.
Zoom Gets or sets a percentage (between 10 and 400 percent) by which the worksheet will be scaled for printing.

See Also

IPageSetup Interface | NativeExcel Namespace | PageSetup Property