PageSetup MembersĀ
Represents the page setup description. The PageSetup object contains all page setup attributes (left margin, bottom margin, paper size, and so on) as properties.
The following tables list the members exposed by the PageSetup type.
Public Properties
Name | Description | |
---|---|---|
Application | Returns an Application object that represents the Microsoft Excel application. | |
BlackAndWhite | True if elements of the document will be printed in black and white. | |
BottomMargin | Returns or sets the size of the bottom margin in points. | |
CenterFooter | Returns or sets the center part of the footer. | |
CenterFooterPicture | Returns a Graphic object that represents the picture for the center section of the footer. Used to set attributes about the picture. | |
CenterHeader | Returns or sets the center part of the header. | |
CenterHeaderPicture | Returns a Graphic object that represents the picture for the center section of the header. Used to set attributes about the picture. | |
CenterHorizontally | True if the sheet is centered horizontally on the page when it's printed. | |
CenterVertically | True if the sheet is centered vertically on the page when it's printed. | |
ChartSize | Returns or sets the way a chart is scaled to fit on a page. | |
Creator | Returns a 32-bit integer that indicates the application in which this object was created. | |
Draft | True if the sheet will be printed without graphics. | |
FirstPageNumber | Returns or sets the first page number that will be used when this sheet is printed. If xlAutomatic, Microsoft Excel chooses the first page number. The default is xlAutomatic. | |
FitToPagesTall | Returns or sets the number of pages tall the worksheet will be scaled to when it's printed. Applies only to worksheets. | |
FitToPagesWide | Returns or sets the number of pages wide the worksheet will be scaled to when it's printed. Applies only to worksheets. | |
FooterMargin | Returns or sets the distance from the bottom of the page to the footer, in points. | |
HeaderMargin | Returns or sets the distance from the top of the page to the header, in points. | |
LeftFooter | Returns or sets the left part of the footer. | |
LeftFooterPicture | Returns a Graphic object that represents the picture for the left section of the footer. Used to set attributes about the picture. | |
LeftHeader | Returns or sets the left part of the header. | |
LeftHeaderPicture | Returns a Graphic object that represents the picture for the left section of the header. Used to set attributes about the picture. | |
LeftMargin | Returns or sets the size of the left margin in points. | |
Order | Returns or sets the order that Microsoft Excel uses to number pages when printing a large worksheet. | |
Orientation | Portrait or landscape printing mode. | |
PaperSize | Returns or sets the size of the paper. | |
Parent | Returns the parent object for the specified object. | |
PrintArea | Returns or sets the range to be printed, as a string using A1-style references in the language of the macro. | |
PrintComments | Returns or sets the way comments are printed with the sheet. | |
PrintErrors | Sets or returns an XlPrintErrors constant specifying the type of print error displayed. This feature allows users to suppress the display of error values when printing a worksheet. | |
PrintGridlines | True if cell gridlines are printed on the page. Applies only to worksheets. | |
PrintHeadings | True if row and column headings are printed with this page. Applies only to worksheets. | |
PrintNotes | True if cell notes are printed as end notes with the sheet. Applies only to worksheets. | |
PrintQuality | Returns or sets the print quality. | |
PrintTitleColumns | Returns 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 in the language of the macro. | |
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 in the language of the macro. | |
RightFooter | Returns or sets the right part of the footer. | |
RightFooterPicture | Returns a Graphic object that represents the picture for the right section of the footer. Used to set attributes of the picture. | |
RightHeader | Returns or sets the right part of the header. | |
RightHeaderPicture | Returns a Graphic object that represents the picture for the right section of the header. Used to set attributes about the picture. | |
RightMargin | Returns or sets the size of the right margin in points. | |
TopMargin | Returns or sets the size of the top margin in points. | |
Zoom | Returns or sets a percentage (between 10 and 400 percent) by which Microsoft Excel will scale the worksheet for printing. Applies only to worksheets. |
Top
See Also
Reference
PageSetup Interface
Microsoft.Office.Interop.Excel Namespace