Click or drag to resize

ExcelPageSetup Properties

The ExcelPageSetup type exposes the following members.

Properties
  NameDescription
Public propertyBottomMargin
Gets or sets the bottom margin size in inches.
Public propertyCenterFooterFormat
Gets or sets the format of the center part of the footer. Formatting and VBA codes for headers and footers are below. &L - Left aligns the characters that follow. &C - Centers the characters that follow. &R - Right aligns the characters that follow. &E - Turns double-underline printing on or off. &X - Turns superscript printing on or off. &Y - Turns subscript printing on or off. &B - Turns bold printing on or off. &I - Turns italic printing on or off. &U - Turns underline printing on or off. &S - Turns strikethrough printing on or off. &"fontname" - Prints the characters that follow in the specified font. Be sure to include the double quotation marks. &nn - Prints the characters that follow in the specified font size. Use a two-digit number to specify a size in points. &color - Prints the characters in the specified color. User supplies a hexidecimal color value. &D - Prints the current date. &T - Prints the current time. &F - Prints the name of the document. &A - Prints the name of the workbook tab. &P - Prints the page number. &P+number - Prints the page number plus the specified number. &P-number - Prints the page number minus the specified number. && - Prints a single ampersand. &N - Prints the total number of pages in the document. &Z - Prints the file path. &G - Inserts an image.
Public propertyCenterFooterPicture
Gets or sets the image displayed in the center part of the footer.
Public propertyCenterHeaderFormat
Gets or sets the format the center part of the header. Formatting and VBA codes for headers and footers are below. &L - Left aligns the characters that follow. &C - Centers the characters that follow. &R - Right aligns the characters that follow. &E - Turns double-underline printing on or off. &X - Turns superscript printing on or off. &Y - Turns subscript printing on or off. &B - Turns bold printing on or off. &I - Turns italic printing on or off. &U - Turns underline printing on or off. &S - Turns strikethrough printing on or off. &"fontname" - Prints the characters that follow in the specified font. Be sure to include the double quotation marks. &nn - Prints the characters that follow in the specified font size. Use a two-digit number to specify a size in points. &color - Prints the characters in the specified color. User supplies a hexidecimal color value. &D - Prints the current date. &T - Prints the current time. &F - Prints the name of the document. &A - Prints the name of the workbook tab. &P - Prints the page number. &P+number - Prints the page number plus the specified number. &P-number - Prints the page number minus the specified number. && - Prints a single ampersand. &N - Prints the total number of pages in the document. &Z - Prints the file path. &G - Inserts an image.
Public propertyCenterHeaderPicture
Gets or sets the image displayed in the center part of the header.
Public propertyCenterHorizontally
Gets or sets indicating if the sheet is centered horizonally.
Public propertyCenterVertically
Gets or sets indicating if the sheet is centered vertically.
Public propertyFooterMargin
Gets or sets the distance from the bottom of the page to the footer in inches.
Public propertyHeaderMargin
Gets or sets the distance from the top of the page to the header in inches.
Public propertyLeftFooterFormat
Gets or sets the format of the left part of the footer. Formatting and VBA codes for headers and footers are below. &L - Left aligns the characters that follow. &C - Centers the characters that follow. &R - Right aligns the characters that follow. &E - Turns double-underline printing on or off. &X - Turns superscript printing on or off. &Y - Turns subscript printing on or off. &B - Turns bold printing on or off. &I - Turns italic printing on or off. &U - Turns underline printing on or off. &S - Turns strikethrough printing on or off. &"fontname" - Prints the characters that follow in the specified font. Be sure to include the double quotation marks. &nn - Prints the characters that follow in the specified font size. Use a two-digit number to specify a size in points. &color - Prints the characters in the specified color. User supplies a hexidecimal color value. &D - Prints the current date. &T - Prints the current time. &F - Prints the name of the document. &A - Prints the name of the workbook tab. &P - Prints the page number. &P+number - Prints the page number plus the specified number. &P-number - Prints the page number minus the specified number. && - Prints a single ampersand. &N - Prints the total number of pages in the document. &Z - Prints the file path. &G - Inserts an image.
Public propertyLeftFooterPicture
Gets or sets the image displayed in the left part of the footer.
Public propertyLeftHeaderFormat
Gets or sets the format of the left part of the header. Formatting and VBA codes for headers and footers are below. &L - Left aligns the characters that follow. &C - Centers the characters that follow. &R - Right aligns the characters that follow. &E - Turns double-underline printing on or off. &X - Turns superscript printing on or off. &Y - Turns subscript printing on or off. &B - Turns bold printing on or off. &I - Turns italic printing on or off. &U - Turns underline printing on or off. &S - Turns strikethrough printing on or off. &"fontname" - Prints the characters that follow in the specified font. Be sure to include the double quotation marks. &nn - Prints the characters that follow in the specified font size. Use a two-digit number to specify a size in points. &color - Prints the characters in the specified color. User supplies a hexidecimal color value. &D - Prints the current date. &T - Prints the current time. &F - Prints the name of the document. &A - Prints the name of the workbook tab. &P - Prints the page number. &P+number - Prints the page number plus the specified number. &P-number - Prints the page number minus the specified number. && - Prints a single ampersand. &N - Prints the total number of pages in the document. &Z - Prints the file path. &G - Inserts an image.
Public propertyLeftHeaderPicture
Gets or sets the image displayed in the left part of the header.
Public propertyLeftMargin
Gets or sets the left margin size in inches.
Public propertyOrientation
Gets or sets the page orientation to portrait or landscape mode.
Public propertyPaperSize
Gets or sets the page paper size.
Public propertyPrintBlackAndWhite
Gets or sets a flag indicating if the page will be printed in black and white.
Public propertyPrintCopiesNumber
Gets or sets the number of copies to print.
Public propertyPrintDraftMode
Gets or sets a flag indicating if the page will be printed in draft mode.
Public propertyPrintFirstPageNumber
Gets or sets the first page number printing. This property has effect if the PrintFirstPageNumberAuto is false.
Public propertyPrintFirstPageNumberAuto
Gets or sets a flag indicating if the first page number is automatically selected by Excel viewer. If this property is false the first page number is given by the PrintFirstPageNumber property.
Public propertyPrintOrder
Gets or sets the order used to number pages when printing a large worksheet.
Public propertyPrintQuality
Gets or sets the print quality in dpi.
Public propertyRightFooterFormat
Gets or sets the format of the right part of the footer. Formatting and VBA codes for headers and footers are below. &L - Left aligns the characters that follow. &C - Centers the characters that follow. &R - Right aligns the characters that follow. &E - Turns double-underline printing on or off. &X - Turns superscript printing on or off. &Y - Turns subscript printing on or off. &B - Turns bold printing on or off. &I - Turns italic printing on or off. &U - Turns underline printing on or off. &S - Turns strikethrough printing on or off. &"fontname" - Prints the characters that follow in the specified font. Be sure to include the double quotation marks. &nn - Prints the characters that follow in the specified font size. Use a two-digit number to specify a size in points. &color - Prints the characters in the specified color. User supplies a hexidecimal color value. &D - Prints the current date. &T - Prints the current time. &F - Prints the name of the document. &A - Prints the name of the workbook tab. &P - Prints the page number. &P+number - Prints the page number plus the specified number. &P-number - Prints the page number minus the specified number. && - Prints a single ampersand. &N - Prints the total number of pages in the document. &Z - Prints the file path. &G - Inserts an image.
Public propertyRightFooterPicture
Gets or sets the image displayed in the right part of the footer.
Public propertyRightHeaderFormat
Gets or sets the format of the right part of the header. Formatting and VBA codes for headers and footers are below. &L - Left aligns the characters that follow. &C - Centers the characters that follow. &R - Right aligns the characters that follow. &E - Turns double-underline printing on or off. &X - Turns superscript printing on or off. &Y - Turns subscript printing on or off. &B - Turns bold printing on or off. &I - Turns italic printing on or off. &U - Turns underline printing on or off. &S - Turns strikethrough printing on or off. &"fontname" - Prints the characters that follow in the specified font. Be sure to include the double quotation marks. &nn - Prints the characters that follow in the specified font size. Use a two-digit number to specify a size in points. &color - Prints the characters in the specified color. User supplies a hexidecimal color value. &D - Prints the current date. &T - Prints the current time. &F - Prints the name of the document. &A - Prints the name of the workbook tab. &P - Prints the page number. &P+number - Prints the page number plus the specified number. &P-number - Prints the page number minus the specified number. && - Prints a single ampersand. &N - Prints the total number of pages in the document. &Z - Prints the file path. &G - Inserts an image.
Public propertyRightHeaderPicture
Gets or sets the image displayed in the right part of the header.
Public propertyRightMargin
Gets or sets the right margin size in inches.
Public propertyTopMargin
Gets or sets the top margin size in inches.
Top
See Also