Home  Products  Purchase  Downloads  Demos  Forums  Blogs  Ticket  Wiki  API  Corporate

com.aspose.cells
Class PageSetup

java.lang.Object
  extended by com.aspose.cells.PageSetup

public class PageSetup
extends java.lang.Object

Encapsulates the object that represents the page setup description. The PageSetup object contains all page setup options.


Method Summary
 double getBottomMargin()
          Gets the size of the bottom margin, in unit of centimeters.
 double getBottomMarginInch()
          Gets the size of the bottom margin, in unit of inches.
 java.lang.String getCenterFooter()
          Gets a script formatting the center section footer of an Excel file.
 java.lang.String getCenterHeader()
          Gets a script formatting the center section header of an Excel file.
 short getFirstPageNumber()
          Gets the first page number that will be used when this sheet is printed.
 short getFitToPagesTall()
          Gets the number of pages tall the worksheet will be scaled to when it's printed.
 short getFitToPagesWide()
          Gets the number of pages wide the worksheet will be scaled to when it's printed.
 double getFooterMargin()
          Gets the distance from the bottom of the page to the footer, in unit of centimeters.
 double getFooterMarginInch()
          Gets the distance from the bottom of the page to the footer, in unit of inches.
 double getHeaderMargin()
          Gets the distance from the top of the page to the header, in unit of centimeters.
 double getHeaderMarginInch()
          Gets the distance from the top of the page to the header, in unit of inches.
 java.lang.String getLeftFooter()
          Gets a script formatting the left section footer of an Excel file.
 java.lang.String getLeftHeader()
          Gets a script formatting the left section header of an Excel file.
 double getLeftMargin()
          Gets the size of the left margin, in unit of centimeters.
 double getLeftMarginInch()
          Gets the size of the left margin, in unit of inches.
 short getOrientation()
          Gets page print orientation.
 short getPageOrder()
          Gets the order that Microsoft Excel uses to number pages when printing a large worksheet.
 short getPaperSize()
          Gets the size of the paper.
 java.lang.String getPrintArea()
          Gets the range to be printed.
 short getPrintComments()
          Gets the way comments are printed with the sheet.
 short getPrintErrors()
          Gets the type of print error displayed.
 short getPrintQuality()
          Gets the print quality.
 java.lang.String getPrintTitleColumns()
          Gets the columns that contain the cells to be repeated on the left side of each page.
 java.lang.String getPrintTitleRows()
          Gets the rows that contain the cells to be repeated at the top of each page.
 java.lang.String getRightFooter()
          Gets a script formatting the right section footer of an Excel file.
 java.lang.String getRightHeader()
          Gets a script formatting the right section header of an Excel file.
 double getRightMargin()
          Gets the size of the right margin, in unit of centimeters.
 double getRightMarginInch()
          Gets the size of the right margin, in unit of inches.
 double getTopMargin()
          Gets the size of the top margin, in unit of centimeters.
 double getTopMarginInch()
          Gets the size of the top margin, in unit of inches.
 short getZoom()
          Gets the scaling factor in percent.
 boolean isBlackAndWhite()
          Indicates whether elements of the document will be printed in black and white.
 boolean isCenterHorizontally()
          Indicates whether the sheet is printed centered horizontally.
 boolean isCenterVertically()
          Indicates whether the sheet is printed centered vertically.
 boolean isDraftQuality()
          Indicats whether the sheet will be printed without graphics.
 boolean isPrintGridlines()
          Indicates cell gridlines are printed on the page.
 boolean isPrintHeadings()
          Indicates whether row and column headings are printed with this page.
 void setBlackAndWhite(boolean blackAndWhite)
          Sets elements of the document will be printed in black and white.
 void setBottomMargin(double bottomMargin)
          Sets the size of the bottom margin, in unit of centimeters.
 void setBottomMarginInch(double bottomMargin)
          Sets the size of the bottom margin, in unit of inches .
 void setCenterFooter(java.lang.String centerFooter)
          Sets a script formatting the center section footer of an Excel file.
 void setCenterHeader(java.lang.String centerHeader)
          Sets na script formatting the center section header of an Excel file
 void setCenterHorizontally(boolean centerHorizontally)
          Sets whether the sheet is printed centered horizontally.
 void setCenterVertically(boolean centerVertically)
          Sets whether the sheet is printed centered vertically.
 void setDraftQuality(boolean draftQuality)
          Sets whether the sheet will be printed without graphics.
 void setFirstPageNumber(short firstPageNumber)
          Sets the first page number that will be used when this sheet is printed.
 void setFitToPagesTall(short fitToPagesTall)
          Sets the number of pages tall the worksheet will be scaled to when it's printed.
 void setFitToPagesWide(short fitToPagesWide)
          Sets the number of pages wide the worksheet will be scaled to when it's printed.
 void setFooterMargin(double footerMargin)
          Sets the distance from the bottom of the page to the footer, in unit of centimeters.
 void setFooterMarginInch(double footerMargin)
          Sets the distance from the bottom of the page to the footer, in unit of inches.
 void setHeaderMargin(double headerMargin)
          Sets the distance from the top of the page to the header, in unit of centimeters.
 void setHeaderMarginInch(double headerMargin)
          Sets the distance from the top of the page to the header, in unit of inches.
 void setLeftFooter(java.lang.String leftFooter)
          Sets a script formatting the left section footer of an Excel file.
 void setLeftHeader(java.lang.String leftHeader)
          Sets a script formatting the left section header of an Excel file.
 void setLeftMargin(double leftMargin)
          Sets the size of the left margin, in unit of centimeters.
 void setLeftMarginInch(double leftMargin)
          Sets the size of the left margin, in unit of inches.
 void setOrientation(short orientation)
          Sets orientation page print orientation.
 void setPageOrder(short pageOrder)
          Sets the order that Microsoft Excel uses to number pages when printing a large worksheet.
 void setPaperSize(short paperSize)
          Sets the size of the paper.
 void setPrintArea(java.lang.String printArea)
          Sets the range to be printed.
 void setPrintComments(short printComments)
          Sets the way comments are printed with the sheet.
 void setPrintErrors(short printErrors)
          Gets the type of print error displayed.
 void setPrintGridlines(boolean printGridlines)
          Sets whether cell gridlines are printed on the page.
 void setPrintHeadings(boolean printHeadings)
          Sets whether row and column headings are printed with this page.
 void setPrintQuality(short printQuality)
          Sets the print quality.
 void setPrintTitleColumns(java.lang.String printTitleColumns)
          Sets the columns that contain the cells to be repeated on the left side of each page.
 void setPrintTitleRows(java.lang.String printTitleRows)
          Sets the rows that contain the cells to be repeated at the top of each page.
 void setRightFooter(java.lang.String rightFooter)
          Sets a script formatting the right section footer of an Excel file.
 void setRightHeader(java.lang.String rightHeader)
          Sets a script formatting the right section header of an Excel file.
 void setRightMargin(double rightMargin)
          Sets the size of the right margin, in unit of centimeters.
 void setRightMarginInch(double rightMargin)
          Sets the size of the right margin, in unit of inches.
 void setTopMargin(double topMargin)
          Sets the size of the top margin, in unit of centimeters.
 void setTopMarginInch(double topMargin)
          Sets the size of the top margin, in unit of inches.
 void setZoom(short zoom)
          Sets the scaling factor in percent.
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Method Detail

isBlackAndWhite

public boolean isBlackAndWhite()
Indicates whether elements of the document will be printed in black and white.

Returns:
whether elements of the document will be printed in black and white.

setBlackAndWhite

public void setBlackAndWhite(boolean blackAndWhite)
Sets elements of the document will be printed in black and white.

Parameters:
blackAndWhite - whether elements of the document will be printed in black and white.
Throws:
ExcelException - if the Page Setup Object has been destroyed.

getBottomMargin

public double getBottomMargin()
Gets the size of the bottom margin, in unit of centimeters.

Returns:
the size of the bottom margin, in unit of centimeters.

setBottomMargin

public void setBottomMargin(double bottomMargin)
Sets the size of the bottom margin, in unit of centimeters.

Parameters:
bottomMargin - the size of the bottom margin, in unit of centimeters.
Throws:
ExcelException - if the Page Setup Object has been destroyed.

getBottomMarginInch

public double getBottomMarginInch()
Gets the size of the bottom margin, in unit of inches.

Returns:
the size of the bottom margin, in unit of inches.

setBottomMarginInch

public void setBottomMarginInch(double bottomMargin)
Sets the size of the bottom margin, in unit of inches .

Parameters:
bottomMargin - the size of the bottom margin, in unit of inches.
Throws:
ExcelException - if the Page Setup Object has been destroyed.

isCenterHorizontally

public boolean isCenterHorizontally()
Indicates whether the sheet is printed centered horizontally.

Returns:
whether the sheet is printed centered horizontally.

setCenterHorizontally

public void setCenterHorizontally(boolean centerHorizontally)
Sets whether the sheet is printed centered horizontally.

Parameters:
centerHorizontally - whether the sheet is printed centered horizontally.
Throws:
ExcelException - if the Page Setup Object has been destroyed.

isCenterVertically

public boolean isCenterVertically()
Indicates whether the sheet is printed centered vertically.

Returns:
whether the sheet is printed centered vertically.

setCenterVertically

public void setCenterVertically(boolean centerVertically)
Sets whether the sheet is printed centered vertically.

Parameters:
centerVertically - whether the sheet is printed centered vertically.
Throws:
ExcelException - if the Page Setup Object has been destroyed.

isDraftQuality

public boolean isDraftQuality()
Indicats whether the sheet will be printed without graphics.

Returns:
whether the sheet will be printed without graphics.

setDraftQuality

public void setDraftQuality(boolean draftQuality)
Sets whether the sheet will be printed without graphics.

Parameters:
draftQuality - whether the sheet will be printed without graphics.
Throws:
ExcelException - if the Page Setup Object has been destroyed.

getFitToPagesTall

public short getFitToPagesTall()
Gets the number of pages tall the worksheet will be scaled to when it's printed.

Returns:
the number of pages tall the worksheet will be scaled to when it's printed.

setFitToPagesTall

public void setFitToPagesTall(short fitToPagesTall)
Sets the number of pages tall the worksheet will be scaled to when it's printed.

Parameters:
fitToPagesTall - the number of pages tall the worksheet will be scaled to when it's printed.
Throws:
java.lang.IllegalArgumentException - if fitToPagesTall <1.
ExcelException - if the Page Setup Object has been destroyed.

getFitToPagesWide

public short getFitToPagesWide()
Gets the number of pages wide the worksheet will be scaled to when it's printed.

Returns:
the number of pages wide the worksheet will be scaled to when it's printed.

setFitToPagesWide

public void setFitToPagesWide(short fitToPagesWide)
Sets the number of pages wide the worksheet will be scaled to when it's printed.

Parameters:
fitToPagesWide - the number of pages wide the worksheet will be scaled to when it's printed.
Throws:
java.lang.IllegalArgumentException - if fitToPagesWide <1.
ExcelException - if the Page Setup Object has been destroyed.

getFooterMargin

public double getFooterMargin()
Gets the distance from the bottom of the page to the footer, in unit of centimeters.

Returns:
the distance from the bottom of the page to the footer, in unit of centimeters.

setFooterMargin

public void setFooterMargin(double footerMargin)
Sets the distance from the bottom of the page to the footer, in unit of centimeters.

Parameters:
footerMargin - the distance from the bottom of the page to the footer, in unit of centimeters.
Throws:
ExcelException - if the Page Setup Object has been destroyed.

getFooterMarginInch

public double getFooterMarginInch()
Gets the distance from the bottom of the page to the footer, in unit of inches.

Returns:
the distance from the bottom of the page to the footer, in unit of inches.

setFooterMarginInch

public void setFooterMarginInch(double footerMargin)
Sets the distance from the bottom of the page to the footer, in unit of inches.

Parameters:
footerMargin - the distance from the bottom of the page to the footer, in unit of inches.
Throws:
ExcelException - if the Page Setup Object has been destroyed.

getHeaderMargin

public double getHeaderMargin()
Gets the distance from the top of the page to the header, in unit of centimeters.

Returns:
the distance from the top of the page to the header, in unit of centimeters.

setHeaderMargin

public void setHeaderMargin(double headerMargin)
Sets the distance from the top of the page to the header, in unit of centimeters.

Parameters:
headerMargin - the distance from the top of the page to the header, in unit of centimeters.
Throws:
ExcelException - if the Page Setup Object has been destroyed.

getHeaderMarginInch

public double getHeaderMarginInch()
Gets the distance from the top of the page to the header, in unit of inches.

Returns:
the distance from the top of the page to the header, in unit of inches.

setHeaderMarginInch

public void setHeaderMarginInch(double headerMargin)
Sets the distance from the top of the page to the header, in unit of inches.

Parameters:
headerMargin - the distance from the top of the page to the header, in unit of inches.
Throws:
ExcelException - if the Page Setup Object has been destroyed.

getCenterFooter

public java.lang.String getCenterFooter()
Gets a script formatting the center section footer of an Excel file.

Returns:
a script formatting the center section footer of an Excel file.
See Also:
setCenterFooter(String)

setCenterFooter

public void setCenterFooter(java.lang.String centerFooter)
Sets a script formatting the center section footer of an Excel file.

Parameters:
centerFooter - a script formatting the center section footer of an Excel file.
Script commands:
Command Description
&PCurrent page number
&NPage count
&DCurrent date
&TCurrent time
&ASheet name
&FFile name without path
&ZFile name with path
&BBold
&IItalic
&UUnderlining
&EDouble underlining
&XSuperscript
&YSubscript
&SStrikeout
&"<FontName>" Font name, for exampe: &"Arial"
&"<FontName>, <FontStyle>" Font name and font style, for exampe: &"Arial,Bold"
&<FontSize> Font size.If this command is followed by a plain number to be printed in the header, it will be separated from the font height with a space character.
Throws:
ExcelException - if the Page Setup Object has been destroyed.

getCenterHeader

public java.lang.String getCenterHeader()
Gets a script formatting the center section header of an Excel file.

Returns:
a script formatting the center section header of an Excel file.
See Also:
setCenterFooter(String)

setCenterHeader

public void setCenterHeader(java.lang.String centerHeader)
Sets na script formatting the center section header of an Excel file

Parameters:
centerHeader - a script formatting the center section header of an Excel file
Throws:
ExcelException - if the Page Setup Object has been destroyed.
See Also:
setCenterFooter(String)

getLeftFooter

public java.lang.String getLeftFooter()
Gets a script formatting the left section footer of an Excel file.

Returns:
a script formatting the left section footer of an Excel file.
See Also:
setCenterFooter(String)

setLeftFooter

public void setLeftFooter(java.lang.String leftFooter)
Sets a script formatting the left section footer of an Excel file.

Parameters:
leftFooter - a script formatting the left section footer of an Excel file.
Throws:
ExcelException - if the Page Setup Object has been destroyed.
See Also:
setCenterFooter(String)

getLeftHeader

public java.lang.String getLeftHeader()
Gets a script formatting the left section header of an Excel file.

Returns:
a script formatting the left section header of an Excel file.
See Also:
setCenterFooter(String)

setLeftHeader

public void setLeftHeader(java.lang.String leftHeader)
Sets a script formatting the left section header of an Excel file.

Parameters:
leftHeader - a script formatting the left section header of an Excel file.
Throws:
ExcelException - if the Page Setup Object has been destroyed.
See Also:
setCenterFooter(String)

getRightFooter

public java.lang.String getRightFooter()
Gets a script formatting the right section footer of an Excel file.

Returns:
a script formatting the right section footer of an Excel file.
See Also:
setCenterFooter(String)

setRightFooter

public void setRightFooter(java.lang.String rightFooter)
Sets a script formatting the right section footer of an Excel file.

Parameters:
rightFooter - a script formatting the right section footer of an Excel file.
Throws:
ExcelException - if the Page Setup Object has been destroyed.
See Also:
setCenterFooter(String)

getRightHeader

public java.lang.String getRightHeader()
Gets a script formatting the right section header of an Excel file.

Returns:
a script formatting the right section header of an Excel file.
See Also:
setCenterFooter(String)

setRightHeader

public void setRightHeader(java.lang.String rightHeader)
Sets a script formatting the right section header of an Excel file.

Parameters:
rightHeader - a script formatting the right section header of an Excel file.
Throws:
ExcelException - if the Page Setup Object has been destroyed.
See Also:
setCenterFooter(String)

getLeftMargin

public double getLeftMargin()
Gets the size of the left margin, in unit of centimeters.

Returns:
the size of the left margin, in unit of centimeters.

setLeftMargin

public void setLeftMargin(double leftMargin)
Sets the size of the left margin, in unit of centimeters.

Parameters:
leftMargin - the size of the left margin, in unit of centimeters.
Throws:
ExcelException - if the Page Setup Object has been destroyed.

getLeftMarginInch

public double getLeftMarginInch()
Gets the size of the left margin, in unit of inches.

Returns:
the size of the left margin, in unit of inches.

setLeftMarginInch

public void setLeftMarginInch(double leftMargin)
Sets the size of the left margin, in unit of inches.

Parameters:
leftMargin - the size of the left margin, in unit of inches.
Throws:
ExcelException - if the Page Setup Object has been destroyed.

getOrientation

public short getOrientation()
Gets page print orientation.

Returns:
page print orientation.
See Also:
setOrientation(short)

setOrientation

public void setOrientation(short orientation)
Sets orientation page print orientation.

Parameters:
orientation - page print orientation. It could be one of the following values:
PageOrientationType.LANDSCAPE
PageOrientationType.PORTRAIT
Throws:
java.lang.IllegalArgumentException - if page orientation type is invalid.
ExcelException - if the Page Setup Object has been destroyed.

getPageOrder

public short getPageOrder()
Gets the order that Microsoft Excel uses to number pages when printing a large worksheet.

Returns:
the order that Microsoft Excel uses to number pages when printing a large worksheet.

setPageOrder

public void setPageOrder(short pageOrder)
Sets the order that Microsoft Excel uses to number pages when printing a large worksheet.

Parameters:
pageOrder - the order that Microsoft Excel uses to number pages when printing a large worksheet.It could be one of the following values:
PrintOrderType.DOWN_THEN_OVER
PrintOrderType.OVER_THEN_DOWN
Throws:
java.lang.IllegalArgumentException - if page print order type is not valid.
ExcelException - if the Page Setup Object has been destroyed.

getPrintArea

public java.lang.String getPrintArea()
Gets the range to be printed.

Returns:
the range to be printed.

setPrintArea

public void setPrintArea(java.lang.String printArea)
Sets the range to be printed.

Parameters:
printArea - the range to be printed.
Throws:
ExcelException - if the Page Setup Object has been destroyed.

getPrintComments

public short getPrintComments()
Gets the way comments are printed with the sheet.

Returns:
the way comments are printed with the sheet.
See Also:
setPrintComments(short)

setPrintComments

public void setPrintComments(short printComments)
Sets the way comments are printed with the sheet.

Parameters:
printComments - the way comments are printed with the sheet. It could be one of the following values:
PrintCommentsType.PRINT_IN_PLACE
PrintCommentsType.PRINT_NO_COMMNENTS
PrintCommentsType.PRINT_SHEET_END
Throws:
java.lang.IllegalArgumentException - if print commnets type is invalid.
ExcelException - if the Page Setup Object has been destroyed.

getPrintErrors

public short getPrintErrors()
Gets the type of print error displayed.

Returns:
the type of print error displayed.
See Also:
setPrintErrors(short)

setPrintErrors

public void setPrintErrors(short printErrors)
Gets the type of print error displayed.

Parameters:
printErrors - the type of print error displayed.It could be one of the following values:
PrintErrorsType.PRINT_ERRORS_BLANK
PrintErrorsType.PRINT_ERRORS_DASH
PrintErrorsType.PRINT_ERRORS_DISPLAYED
PrintErrorsType.PRINT_ERRORS_NA
Throws:
java.lang.IllegalArgumentException - if print errors type is invalid.
ExcelException - if the Page Setup Object has been destroyed.

isPrintGridlines

public boolean isPrintGridlines()
Indicates cell gridlines are printed on the page.

Returns:
whether cell gridlines are printed on the page.

setPrintGridlines

public void setPrintGridlines(boolean printGridlines)
Sets whether cell gridlines are printed on the page.

Parameters:
printGridlines - whether cell gridlines are printed on the page.
Throws:
ExcelException - if the Page Setup Object has been destroyed.

isPrintHeadings

public boolean isPrintHeadings()
Indicates whether row and column headings are printed with this page.

Returns:
whether row and column headings are printed with this page.

setPrintHeadings

public void setPrintHeadings(boolean printHeadings)
Sets whether row and column headings are printed with this page.

Parameters:
printHeadings - whether row and column headings are printed with this page.
Throws:
ExcelException - if the Page Setup Object has been destroyed.

getPrintQuality

public short getPrintQuality()
Gets the print quality.

Returns:
the print quality.

setPrintQuality

public void setPrintQuality(short printQuality)
Sets the print quality.

Parameters:
printQuality - the print quality.
Throws:
java.lang.IllegalArgumentException - if printQuality is less than 0.
ExcelException - if the Page Setup Object has been destroyed.

getPrintTitleColumns

public java.lang.String getPrintTitleColumns()
Gets the columns that contain the cells to be repeated on the left side of each page.

Returns:
the columns that contain the cells to be repeated on the left side of each page.

setPrintTitleColumns

public void setPrintTitleColumns(java.lang.String printTitleColumns)
Sets the columns that contain the cells to be repeated on the left side of each page.

Parameters:
printTitleColumns - the columns that contain the cells to be repeated on the left side of each page.
Throws:
ExcelException - if the Page Setup Object has been destroyed.
java.lang.IllegalArgumentException - if print titles columns are invalid.

getPrintTitleRows

public java.lang.String getPrintTitleRows()
Gets the rows that contain the cells to be repeated at the top of each page.

Returns:
the rows that contain the cells to be repeated at the top of each page.

setPrintTitleRows

public void setPrintTitleRows(java.lang.String printTitleRows)
Sets the rows that contain the cells to be repeated at the top of each page.

Parameters:
printTitleRows - the rows that contain the cells to be repeated at the top of each page.
Throws:
ExcelException - if the Page Setup Object has been destroyed.
java.lang.IllegalArgumentException - if print titles rows are invalid.

getRightMargin

public double getRightMargin()
Gets the size of the right margin, in unit of centimeters.

Returns:
the size of the right margin, in unit of centimeters.

setRightMargin

public void setRightMargin(double rightMargin)
Sets the size of the right margin, in unit of centimeters.

Parameters:
rightMargin - the size of the right margin, in unit of centimeters.
Throws:
ExcelException - if the Page Setup Object has been destroyed.

getRightMarginInch

public double getRightMarginInch()
Gets the size of the right margin, in unit of inches.

Returns:
the size of the right margin, in unit of inches.

setRightMarginInch

public void setRightMarginInch(double rightMargin)
Sets the size of the right margin, in unit of inches.

Parameters:
rightMargin - the size of the right margin, in unit of inches.
Throws:
ExcelException - if the Page Setup Object has been destroyed.

getTopMargin

public double getTopMargin()
Gets the size of the top margin, in unit of centimeters.

Returns:
the size of the top margin, in unit of centimeters.

setTopMargin

public void setTopMargin(double topMargin)
Sets the size of the top margin, in unit of centimeters.

Parameters:
topMargin - the size of the top margin, in unit of centimeters.
Throws:
ExcelException - if the Page Setup Object has been destroyed.

getTopMarginInch

public double getTopMarginInch()
Gets the size of the top margin, in unit of inches.

Returns:
the size of the top margin, in unit of inches.

setTopMarginInch

public void setTopMarginInch(double topMargin)
Sets the size of the top margin, in unit of inches.

Parameters:
topMargin - the size of the top margin, in unit of inches.
Throws:
ExcelException - if the Page Setup Object has been destroyed.

getZoom

public short getZoom()
Gets the scaling factor in percent. It should be between 10 and 400.

Returns:
the scaling factor in percent. It should be between 10 and 400.

setZoom

public void setZoom(short zoom)
Sets the scaling factor in percent. It should be between 10 and 400.

Parameters:
zoom - the scaling factor in percent. It should be between 10 and 400.
Throws:
java.lang.IllegalArgumentException - if zoom is not between 10 and 400.
ExcelException - if the Page Setup Object has been destroyed.

getPaperSize

public short getPaperSize()
Gets the size of the paper.

Returns:
the size of the paper.

setPaperSize

public void setPaperSize(short paperSize)
Sets the size of the paper.

Parameters:
paperSize - the size of the paper.It could be one of the members of PaperSizeType.
Throws:
java.lang.IllegalArgumentException - if page size type is not valid.
ExcelException - if the Page Setup Object has been destroyed.
See Also:
PaperSizeType

getFirstPageNumber

public short getFirstPageNumber()
Gets the first page number that will be used when this sheet is printed.

Returns:
the first page number that will be used when this sheet is printed.

setFirstPageNumber

public void setFirstPageNumber(short firstPageNumber)
Sets the first page number that will be used when this sheet is printed.

Parameters:
firstPageNumber - the first page number that will be used when this sheet is printed.
Throws:
ExcelException - if the Page Setup Object has been destroyed.