ExpertXls Excel Library for .NET
ExcelPageSetup Class
Namespaces ► ExpertXls.ExcelLib ► ExcelPageSetup
ExpertXls Excel Library for .NET
Represents the Excel page setup.
Declaration Syntax

C# | Visual Basic | Visual C++

    public class ExcelPageSetup

    Public Class ExcelPageSetup

    public ref class ExcelPageSetup

Members

All Members | Methods | Properties
Public Protected | Instance Static | Declared Inherited

Icon | Member | Description
--- | --- | ---
| BottomMargin | Gets or sets the bottom margin size in inches.
| CenterFooterFormat | 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.
| CenterFooterPicture | Gets or sets the image displayed in the center part of the footer.
| CenterHeaderFormat | 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.
| CenterHeaderPicture | Gets or sets the image displayed in the center part of the header.
| CenterHorizontally | Gets or sets indicating if the sheet is centered horizonally.
| CenterVertically | Gets or sets indicating if the sheet is centered vertically.
| Equals(Object) | Determines whether the specified Object is equal to the current Object. (Inherited from Object.)
| Finalize()()() | Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection. (Inherited from Object.)
| FooterMargin | Gets or sets the distance from the bottom of the page to the footer in inches.
| GetHashCode()()() | Serves as a hash function for a particular type. (Inherited from Object.)
| GetType()()() | Gets the Type of the current instance. (Inherited from Object.)
| HeaderMargin | Gets or sets the distance from the top of the page to the header in inches.
| LeftFooterFormat | 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.
| LeftFooterPicture | Gets or sets the image displayed in the left part of the footer.
| LeftHeaderFormat | 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.
| LeftHeaderPicture | Gets or sets the image displayed in the left part of the header.
| LeftMargin | Gets or sets the left margin size in inches.
| MemberwiseClone()()() | Creates a shallow copy of the current Object. (Inherited from Object.)
| Orientation | Gets or sets the page orientation to portrait or landscape mode.
| PaperSize | Gets or sets the page paper size.
| PrintBlackAndWhite | Gets or sets a flag indicating if the page will be printed in black and white.
| PrintCopiesNumber | Gets or sets the number of copies to print.
| PrintDraftMode | Gets or sets a flag indicating if the page will be printed in draft mode.
| PrintFirstPageNumber | Gets or sets the first page number printing. This property has effect if the PrintFirstPageNumberAuto is false.
| PrintFirstPageNumberAuto | 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.
| PrintOrder | Gets or sets the order used to number pages when printing a large worksheet.
| PrintQuality | Gets or sets the print quality in dpi.
| RightFooterFormat | 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.
| RightFooterPicture | Gets or sets the image displayed in the right part of the footer.
| RightHeaderFormat | 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.
| RightHeaderPicture | Gets or sets the image displayed in the right part of the header.
| RightMargin | Gets or sets the right margin size in inches.
| TopMargin | Gets or sets the top margin size in inches.
| ToString()()() | Returns a String that represents the current Object. (Inherited from Object.)

Inheritance Hierarchy

Object
| ExcelPageSetup
|  | ExcelChartWorksheetPageSetup
|  | ExcelWorksheetPageSetup

Assembly: ExpertXls.ExcelLib (Module: ExpertXls.ExcelLib) Version: 2.1.0.0 (2.1.0.0)