PageSetup Class

Indicates whether align header footer margins with page margins.default is 1

Indicates whether FirstPageNumber is set to Auto or not.

Gets / sets background image.

True if elements of the document will be printed in black and white. Read / write Boolean.

Returns or sets the size of the bottom margin, in inches. Read / write Double.

Returns or sets the center part of the footer. Read / write String.

Gets / set image for center part of the footer.

Gets or set crop bottom height of picture for center part of the footer,in unit of centimeters.

Gets or set crop left width of picture for center part of the footer,in unit of centimeters.

Gets or set crop right width of picture for center part of the footer,in unit of centimeters.

Gets or set crop top height of picture for center part of the footer,in unit of centimeters.

Gets or set height of picture for center part of the footer.

Gets or set width of picture for center part of the footer.

Returns or sets the center part of the header. Read / write String.

Gets / set image for center part of the header.

Gets or set crop bottom height of picture for center part of the header,in unit of centimeters.

Gets or set crop left width of picture for center part of the header,in unit of centimeters.

Gets or set crop right width of picture for center part of the header,in unit of centimeters.

Gets or set crop top height of picture for center part of the header,in unit of centimeters.

Gets or set height of picture for center part of the header.

Gets or set width of picture for center part of the header.

True if the sheet is centered horizontally on the page when it is printed. Read / write Boolean.

True if the sheet is centered vertically on the page when it is printed. Read / write Boolean.

Number of copies to print.

Returns or sets the name of custom paper that is from printer.

Gets or sets default row height.

Indicates whether different first page header and footer.default is 0

Indicates whether different odd and even page headers and footers.default is 0

True if the sheet will be printed without graphics. Read / write Boolean.

Gets OddEven page footer string. Read only.

Gets Even page header string. Read only.

Gets first page footer string. Read only.

Represents first page header string. Read only.

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. Read / write Long.

Returns or sets the number of pages tall the worksheet will be scaled to when it is printed. Applies only to worksheets. Read / write int.

Returns or sets the number of pages wide the worksheet will be scaled to when it is printed. Applies only to worksheets. Read / write int.

Returns or sets the distance from the bottom of the page to the footer, in inches. Read / write Double.

Gets footer full string. Read only.

Represents full header string. Read only.

Returns or sets the distance from the top of the page to the header, in inches. Read / write Double.

Get horizontal page breaks.

Gets or sets horizontal resolution in dpi.

Returns whether paper size is automatic. Read only.

Indicates whether fit to page mode is selected.

True if cell gridlines are printed on the page. Applies only to worksheets. Read / write Boolean.

True if row and column headings are printed with this page. Applies only to worksheets. Read / write Boolean.

Indicates whether paper size, scaling factor, paper orientation (portrait / landscape), print resolution, and number of copies are not initialized.

Indicates whether summary columns will appear right of the detail in outlines.

Indicates whether summary rows will appear below detail in outlines.

Returns or sets the left part of the footer. Read / write String. &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. &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. & "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. &N Prints the total number of pages in the document.

Gets / set image for left part of the footer.

Gets or set crop bottom height of picture for left part of the footer,in unit of centimeters.

Gets or set crop left width of picture for left part of the footer,in unit of centimeters.

Gets or set crop right width of picture for left part of the footer,in unit of centimeters.

Gets or set crop top height of picture for left part of the footer,in unit of centimeters.

Gets or set height of picture for left part of the footer.

Gets or set width of picture for left part of the footer.

Returns or sets the left part of the header. Read / write String.

Gets / set image for left part of the header.

Gets or set crop bottom height of picture for left part of the header,in unit of centimeters.

Gets or set crop left width of picture for left part of the header,in unit of centimeters.

Gets or set crop right width of picture for left part of the header,in unit of centimeters.

Gets or set crop top height of picture for left part of the header,in unit of centimeters.

Gets or set height of picture for left part of the header.

Gets or set width of picture for left part of the header.

Returns or sets the size of the left margin, in inches. Read / write Double.

Indicates whether data array is required by this record.

Gets Odd page footer string. Read only.

Gets Odd page header string. Read only.

Returns ods page background. Read-only.

Returns or sets the order that Microsoft Excel uses to number pages when printing a large worksheet. Read / write ExcelOrder.

Portrait or landscape printing mode. Read / write ExcelPageOrientation.

Returns page width in points. Read-only.

Returns page width in points. Read-only.

Returns or sets the size of the paper. Read / write ExcelPaperSize.

Reference to Parent object. Read-only.

Returns or sets the range to be printed, as a string using A1-style references in the language of the macro. Read / write String.

Returns or sets the way comments are printed with the sheet. Read / write ExcelPrintLocation.

Sets or returns an ExcelPrintErrors constant specifying the type of print error displayed. This feature allows users to suppress the display of error values when printing a worksheet. Read / write.

Returns or sets the settings of the printer.

True if cell notes are printed as end notes with the sheet. Applies only to worksheets. Read / write Boolean.

Returns or sets the print quality. Read / write ushort.

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. Read / write String.

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. Read / write String.

Returns code of the biff storage. Read-only.

Get quantity of instance references.

Gets / sets relation id to the printer settings part.

Returns or sets the right part of the footer. Read / write String.

Gets / set image for right part of the footer.

Gets or set crop bottom height of picture for right part of the footer,in unit of centimeters.

Gets or set crop left width of picture for right part of the footer,in unit of centimeters.

Gets or set crop right width of picture for right part of the footer,in unit of centimeters.

Gets or set crop top height of picture for right part of the footer,in unit of centimeters.

Gets or set height of picture for right part of the footer.

Gets or set width of picture for right part of the footer.

Returns or sets the right part of the header. Read / write String.

Gets / set image for right part of the header.

Gets or set crop bottom height of picture for right part of the header,in unit of centimeters.

Gets or set crop left width of picture for right part of the header,in unit of centimeters.

Gets or set crop right width of picture for right part of the header,in unit of centimeters.

Gets or set crop top height of picture for right part of the header,in unit of centimeters.

Gets or set height of picture for right part of the header.

Gets or set width of picture for right part of the header.

Returns or sets the size of the right margin, in inches. Read / write Double.

Indicates whether scale header and footer with document scaling.default is 1

Indicates record position in stream. This is a utility member of class and is used only in the serialization process. Does not influence the data.

Returns or sets the size of the top margin, in inches. Read / write Double.

Get vertical page breaks.

Gets or sets vertical resolution in dpi.

Returns or sets a percentage (between 10 and 400 percent) by which Microsoft Excel will scale the worksheet for printing. Applies only to worksheets. Read / write ushort.

Increase the quantity of reference. User must use this method when new wrapper on object is created or reference on object stored.

Checks whether object was disposed and throws exception if it was.

Creates copy of the current instance.

Copies the settings from the source PageSetup to the current PageSetup.

Dispose object and free resources.

Determines whether the specified object is equal to the current object.

Destructor. Call dispose method of current object.

This method is used to find parent with specific type.

Find parent of object.

This method is used to find parent with specific type.

Finds parent objects.

Serves as the default hash function.

Size of the required storage space. Read-only.

Gets the Type of the current instance.

Creates a shallow copy of the current Object .

Method which can be overriden by users to take any specific actions when object is disposed.

Decrease quantity of Reference. User must call this method when freeing resources.

Sets the custom paper size. Unit mm.

Sets parent of the object.

Returns a string that represents the current object.

Flag which indicates if the object was disposed or not.