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

C# | Visual Basic | Visual C++

    public class ExcelWorksheetPageSetup : ExcelPageSetup

    Public Class ExcelWorksheetPageSetup _
    	Inherits ExcelPageSetup

    public ref class ExcelWorksheetPageSetup : public ExcelPageSetup

Members

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

Icon | Member | Description
--- | --- | ---
| BackgroundPicture | Gets or sets the background picture of the worksheet.
| BottomMargin | Gets or sets the bottom margin size in inches. (Inherited from ExcelPageSetup.)
| 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. (Inherited from ExcelPageSetup.)
| CenterFooterPicture | Gets or sets the image displayed in the center part of the footer. (Inherited from ExcelPageSetup.)
| 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. (Inherited from ExcelPageSetup.)
| CenterHeaderPicture | Gets or sets the image displayed in the center part of the header. (Inherited from ExcelPageSetup.)
| CenterHorizontally | Gets or sets indicating if the sheet is centered horizonally. (Inherited from ExcelPageSetup.)
| CenterVertically | Gets or sets indicating if the sheet is centered vertically. (Inherited from ExcelPageSetup.)
| 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.)
| FitToPagesMode | Gets or sets a value that indicates whether the worksheet is scaled for printing using Zoom property or FitToPagesWide and FitToPagesTall properties. Default value is false.
| 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. (Inherited from ExcelPageSetup.)
| 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. (Inherited from ExcelPageSetup.)
| 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. (Inherited from ExcelPageSetup.)
| LeftFooterPicture | Gets or sets the image displayed in the left part of the footer. (Inherited from ExcelPageSetup.)
| 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. (Inherited from ExcelPageSetup.)
| LeftHeaderPicture | Gets or sets the image displayed in the left part of the header. (Inherited from ExcelPageSetup.)
| LeftMargin | Gets or sets the left margin size in inches. (Inherited from ExcelPageSetup.)
| MemberwiseClone()()() | Creates a shallow copy of the current Object. (Inherited from Object.)
| Orientation | Gets or sets the page orientation to portrait or landscape mode. (Inherited from ExcelPageSetup.)
| PaperSize | Gets or sets the page paper size. (Inherited from ExcelPageSetup.)
| PrintArea | Gets or sets the range to be printed as a range reference string using A1 notation (e.g. A1:E8).
| PrintBlackAndWhite | Gets or sets a flag indicating if the page will be printed in black and white. (Inherited from ExcelPageSetup.)
| PrintCommentsLocation | Gets or sets the location where the comments are printed
| PrintCopiesNumber | Gets or sets the number of copies to print. (Inherited from ExcelPageSetup.)
| PrintDraftMode | Gets or sets a flag indicating if the page will be printed in draft mode. (Inherited from ExcelPageSetup.)
| PrintErrorsMode | Gets or sets the mode the errors are printed.
| PrintFirstPageNumber | Gets or sets the first page number printing. This property has effect if the PrintFirstPageNumberAuto is false. (Inherited from ExcelPageSetup.)
| 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. (Inherited from ExcelPageSetup.)
| PrintGridlines | Gets or sets a flag indicating if the cell gridlines are printed on the page.
| PrintHeadings | Gets or sets a flag indicating if the row and column headings are printed with this page.
| PrintNotes | Gets or sets a flag indicating if the cell notes are printed as end notes in the worksheet.
| PrintOrder | Gets or sets the order used to number pages when printing a large worksheet. (Inherited from ExcelPageSetup.)
| PrintQuality | Gets or sets the print quality in dpi. (Inherited from ExcelPageSetup.)
| 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 notation (e.g. $A:$B).
| PrintTitleRows | Gets or sets the rows that contain the cells to be repeated at the top of each page, as a string in A1 notation (e.g. $1:$2).
| 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. (Inherited from ExcelPageSetup.)
| RightFooterPicture | Gets or sets the image displayed in the right part of the footer. (Inherited from ExcelPageSetup.)
| 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. (Inherited from ExcelPageSetup.)
| RightHeaderPicture | Gets or sets the image displayed in the right part of the header. (Inherited from ExcelPageSetup.)
| RightMargin | Gets or sets the right margin size in inches. (Inherited from ExcelPageSetup.)
| TopMargin | Gets or sets the top margin size in inches. (Inherited from ExcelPageSetup.)
| ToString()()() | Returns a String that represents the current Object. (Inherited from Object.)
| Zoom | Returns or sets a percentage between 10 and 400 percent by which the the worksheet will be scaled for printing.

Inheritance Hierarchy

Object
| ExcelPageSetup
|  | ExcelWorksheetPageSetup

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