com.spire.xls.core.spreadsheet
Class XlsPageSetupBase

java.lang.Object
  com.spire.xls.core.spreadsheet.XlsObject
      com.spire.xls.core.spreadsheet.XlsPageSetupBase

All Implemented Interfaces:

IPageSetupBase

Direct Known Subclasses:

XlsChartPageSetup, XlsPageSetup

public class XlsPageSetupBase
extends XlsObject
implements IPageSetupBase

Summary description for PageSetupBaseImpl.

Constructor Summary

XlsPageSetupBase(java.lang.Object parent)

Method Summary

byte	getAlignWithMargins() Indicates whether align header footer margins with page margins.Default value is 1
boolean	getAutoFirstPageNumber() Indicates whether FirstPageNumber is set to Auto or not.
java.awt.image.BufferedImage	getBackgoundImage() Gets / sets background image.
boolean	getBlackAndWhite() True if elements of the document will be printed in black and white.
double	getBottomMargin() Returns or sets the size of the bottom margin, in inches.
java.lang.String	getCenterFooter() Returns or sets the center part of the footer.
java.awt.image.BufferedImage	getCenterFooterImage() Gets / set image for center part of the footer.
int	getCenterFooterPictureHeight() Gets or set height of picture for center part of the footer.
int	getCenterFooterPictureWidth() Gets or set width of picture for center part of the footer.
java.lang.String	getCenterHeader() Returns or sets the center part of the header.
java.awt.image.BufferedImage	getCenterHeaderImage() Gets / set image for center part of the header.
int	getCenterHeaderPictureHeight() Gets or set height of picture for center part of the header.
int	getCenterHeaderPictureWidth() Gets or set width of picture for center part of the header.
boolean	getCenterHorizontally() True if the sheet is centered horizontally on the page when it is printed.
boolean	getCenterVertically() True if the sheet is centered vertically on the page when it is printed.
int	getCopies() Number of copies to print.
byte	getDifferentFirst() Indicates whether different first page header and footer.Default value is 0
byte	getDifferentOddEven() Indicates whether different odd and even page headers and footers.Default value is 0
boolean	getDraft() True if the sheet will be printed without graphics.
java.lang.String	getEvenFooterString() Gets OddEven page footer string.
java.lang.String	getEvenHeaderString() Gets Even page header string.
java.lang.String	getFirstFooterString() Gets first page footer string.
java.lang.String	getFirstHeaderString() Represents first page header string.
int	getFirstPageNumber() Returns or sets the first page number that will be used when this sheet is printed.
int	getFitToPagesTall() Returns or sets the number of pages tall the worksheet will be scaled to when it is printed.
int	getFitToPagesWide() Returns or sets the number of pages wide the worksheet will be scaled to when it is printed.
double	getFooterMarginInch() Returns or sets the distance from the bottom of the page to the footer, in inches.
java.lang.String	getFullFooterString() Gets footer full string.
java.lang.String	getFullHeaderString() Represents full header string.
double	getHeaderMarginInch() Returns or sets the distance from the top of the page to the header, in inches.
int	getHResolution() Gets or sets horizontal resolution in dpi.
java.lang.String	getLeftFooter() Returns or sets the left part of the footer.
java.awt.image.BufferedImage	getLeftFooterImage() Gets / set image for left part of the footer.
int	getLeftFooterPictureHeight() Gets or set height of picture for left part of the footer.
int	getLeftFooterPictureWidth() Gets or set width of picture for left part of the footer.
java.lang.String	getLeftHeader() Returns or sets the left part of the header.
java.awt.image.BufferedImage	getLeftHeaderImage() Gets / set image for left part of the header.
int	getLeftHeaderPictureHeight() Gets or set height of picture for left part of the header.
int	getLeftHeaderPictureWidth() Gets or set width of picture for left part of the header.
double	getLeftMargin() Returns the size of the left margin, in inches.
java.lang.String	getOddFooterString() Gets Odd page footer string.
java.lang.String	getOddHeaderString() Gets Odd page header string.
OrderType	getOrder() Returns order that Microsoft Excel uses to number pages when printing a large worksheet.
PageOrientationType	getOrientation() Portrait or landscape printing mode.
double	getPageHeight() Returns page width in points.
double	getPageWidth() Returns page width in points.
PaperSizeType	getPaperSize() Returns the size of the paper.
PrintCommentType	getPrintComments() Returns or sets the way comments are printed with the sheet.
PrintErrorsType	getPrintErrors() Sets or returns an ExcelPrintErrors constant specifying the type of print error displayed.
java.lang.String	getRightFooter() Returns or sets the right part of the footer.
java.awt.image.BufferedImage	getRightFooterImage() Gets / set image for right part of the footer.
int	getRightFooterPictureHeight() Gets or set height of picture for right part of the footer.
int	getRightFooterPictureWidth() Gets or set width of picture for right part of the footer.
java.lang.String	getRightHeader() Returns or sets the right part of the header.
java.awt.image.BufferedImage	getRightHeaderImage() Gets / set image for right part of the header.
int	getRightHeaderPictureHeight() Gets or set height of picture for right part of the header.
int	getRightHeaderPictureWidth() Gets or set width of picture for right part of the header.
double	getRightMargin() Returns the size of the right margin, in inches.
byte	getScaleWithDoc() Indicates whether scale header and footer with document scaling.Default value is 1
double	getTopMargin() Returns the size of the top margin, in inches.
int	getVResolution() Gets vertical resolution in dpi.
int	getZoom() Returns a percentage (between 10 and 400 percent) by which Microsoft Excel will scale the worksheet for printing.
void	setAlignWithMargins(byte value) Indicates whether align header footer margins with page margins.Default value is 1
void	setAutoFirstPageNumber(boolean value) Indicates whether FirstPageNumber is set to Auto or not.
void	setBackgoundImage(java.awt.image.BufferedImage image) Gets / sets background image.
void	setBlackAndWhite(boolean value) True if elements of the document will be printed in black and white.
void	setBottomMargin(double bottomMargin) Sets the size of the bottom margin, in inches.
void	setCenterFooter(java.lang.String centerFooter) Sets the center part of the footer.
void	setCenterFooterImage(java.awt.image.BufferedImage image) Sets image for center part of the footer.
void	setCenterFooterPictureHeight(int value) Gets or set height of picture for center part of the footer.
void	setCenterFooterPictureWidth(int value) Gets or set width of picture for center part of the footer.
void	setCenterHeader(java.lang.String value) Returns or sets the center part of the header.
void	setCenterHeaderImage(java.awt.image.BufferedImage image) Gets / set image for center part of the header.
void	setCenterHeaderImage(java.awt.image.BufferedImage image, float scale)
void	setCenterHeaderPictureHeight(int value) Gets or set height of picture for center part of the header.
void	setCenterHeaderPictureWidth(int value) Gets or set width of picture for center part of the header.
void	setCenterHorizontally(boolean value) True if the sheet is centered horizontally on the page when it is printed.
void	setCenterVertically(boolean value) True if the sheet is centered vertically on the page when it is printed.
void	setCopies(int value) Number of copies to print.
void	setDifferentFirst(byte value) Indicates whether different first page header and footer.Default value is 0
void	setDifferentOddEven(byte differentOddEven) Indicates whether different odd and even page headers and footers.
void	setDraft(boolean value) True if the sheet will be printed without graphics.
void	setEvenFooterString(java.lang.String evenFooterString) Sets odd even page footer string.
void	setEvenHeaderString(java.lang.String evenHeaderString) Sets even page header string.
void	setFirstFooterString(java.lang.String value) Gets first page footer string.
void	setFirstHeaderString(java.lang.String value) Represents first page header string.
void	setFirstPageNumber(int value) Returns or sets the first page number that will be used when this sheet is printed.
void	setFitToPagesTall(int value) Returns or sets the number of pages tall the worksheet will be scaled to when it is printed.
void	setFitToPagesWide(int value) Returns or sets the number of pages wide the worksheet will be scaled to when it is printed.
void	setFooterMarginInch(double value) Returns or sets the distance from the bottom of the page to the footer, in inches.
void	setFullFooterString(java.lang.String value) Gets footer full string.
void	setFullHeaderString(java.lang.String value) Represents full header string.
void	setHeaderMarginInch(double value) Returns or sets the distance from the top of the page to the header, in inches.
void	setHResolution(int value) Gets or sets horizontal resolution in dpi.
void	setLeftFooter(java.lang.String value) Returns or sets the left part of the footer.
void	setLeftFooterImage(java.awt.image.BufferedImage value) set image for left part of the footer.
void	setLeftFooterPictureHeight(int value) Gets or set height of picture for left part of the footer.
void	setLeftFooterPictureWidth(int value) Gets or set width of picture for left part of the footer.
void	setLeftHeader(java.lang.String leftHeader) Sets the left part of the header.
void	setLeftHeaderImage(java.awt.image.BufferedImage bufferedImage) Sets image for left part of the header.
void	setLeftHeaderImage(java.awt.image.BufferedImage bufferedImage, float scale) Sets image for left part of the header.
void	setLeftHeaderPictureHeight(int value) Gets or set height of picture for left part of the header.
void	setLeftHeaderPictureWidth(int value) Gets or set width of picture for left part of the header.
void	setLeftMargin(double leftMargin) Sets the value of the left margin, in inches.
void	setOddFooterString(java.lang.String oddFooterString) Sets odd page footer string.
void	setOddHeaderString(java.lang.String oddHeaderString) Sets odd page header string.
void	setOrder(OrderType value) Sets the order that Microsoft Excel uses to number pages when printing a large worksheet.
void	setOrientation(PageOrientationType orientation) Sets portrait or landscape printing mode.
void	setPaperSize(PaperSizeType paperSize) Sets the size of the paper.
void	setPrintComments(PrintCommentType value) Returns or sets the way comments are printed with the sheet.
void	setPrintErrors(PrintErrorsType value) Sets or returns an ExcelPrintErrors constant specifying the type of print error displayed.
void	setRightFooter(java.lang.String value) Returns or sets the right part of the footer.
void	setRightFooterImage(java.awt.image.BufferedImage image) set image for right part of the footer.
void	setRightFooterPictureHeight(int value) Gets or set height of picture for right part of the footer.
void	setRightFooterPictureWidth(int value) Gets or set width of picture for right part of the footer.
void	setRightHeader(java.lang.String value) Returns or sets the right part of the header.
void	setRightHeaderImage(java.awt.image.BufferedImage bufferedImage) set image for right part of the header.
void	setRightHeaderImage(java.awt.image.BufferedImage bufferedImage, float scale) set image for right part of the header.
void	setRightHeaderPictureHeight(int value) Gets or set height of picture for right part of the header.
void	setRightHeaderPictureWidth(int value) Gets or set width of picture for right part of the header.
void	setRightMargin(double rightMargin) Sets the size of the right margin, in inches.
void	setScaleWithDoc(byte value) Indicates whether scale header and footer with document scaling.Default value is 1
void	setTopMargin(double topMargin) Sets the size of the top margin, in inches.
void	setVResolution(int value) Sets vertical resolution in dpi.
void	setZoom(int value) Sets a percentage (between 10 and 400 percent) by which Microsoft Excel will scale the worksheet for printing.

Methods inherited from class com.spire.xls.core.spreadsheet.XlsObject

dispose

Methods inherited from interface com.spire.xls.core.interfacess.IPageSetupBase

getBackgoundInnerImage, getPrintNotes, getPrintQuality, setBackgoundInnerImage, setPrintNotes, setPrintQuality

Constructor Detail

XlsPageSetupBase

public XlsPageSetupBase(java.lang.Object parent)

Method Detail

getAutoFirstPageNumber

public boolean getAutoFirstPageNumber()

Indicates whether FirstPageNumber is set to Auto or not.

Specified by:

getAutoFirstPageNumber in interface IPageSetupBase

setAutoFirstPageNumber

public void setAutoFirstPageNumber(boolean value)

Indicates whether FirstPageNumber is set to Auto or not.

Specified by:

setAutoFirstPageNumber in interface IPageSetupBase

getBlackAndWhite

public boolean getBlackAndWhite()

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

Specified by:

getBlackAndWhite in interface IPageSetupBase

setBlackAndWhite

public void setBlackAndWhite(boolean value)

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

Specified by:

setBlackAndWhite in interface IPageSetupBase

getBottomMargin

public double getBottomMargin()

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

Specified by:

getBottomMargin in interface IPageSetupBase

setBottomMargin

public void setBottomMargin(double bottomMargin)

Sets the size of the bottom margin, in inches. Write double.

Specified by:

setBottomMargin in interface IPageSetupBase

getCenterFooter

public java.lang.String getCenterFooter()

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

Specified by:

getCenterFooter in interface IPageSetupBase

setCenterFooter

public void setCenterFooter(java.lang.String centerFooter)

Sets the center part of the footer. Write string.

Specified by:

setCenterFooter in interface IPageSetupBase

getCenterFooterImage

public java.awt.image.BufferedImage getCenterFooterImage()

Gets / set image for center part of the footer.

Specified by:

getCenterFooterImage in interface IPageSetupBase

Returns:

setCenterFooterImage

public void setCenterFooterImage(java.awt.image.BufferedImage image)

Sets image for center part of the footer.

Specified by:

setCenterFooterImage in interface IPageSetupBase

Parameters:

image -

getCenterHeader

public java.lang.String getCenterHeader()

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

Specified by:

getCenterHeader in interface IPageSetupBase

setCenterHeader

public void setCenterHeader(java.lang.String value)

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

Specified by:

setCenterHeader in interface IPageSetupBase

getCenterHeaderImage

public java.awt.image.BufferedImage getCenterHeaderImage()

Gets / set image for center part of the header.

Specified by:

getCenterHeaderImage in interface IPageSetupBase

Returns:

setCenterHeaderImage

public void setCenterHeaderImage(java.awt.image.BufferedImage image)

Description copied from interface: IPageSetupBase

Gets / set image for center part of the header.

Specified by:

setCenterHeaderImage in interface IPageSetupBase

setCenterHeaderImage

public void setCenterHeaderImage(java.awt.image.BufferedImage image,
                                 float scale)

getCenterHorizontally

public boolean getCenterHorizontally()

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

Specified by:

getCenterHorizontally in interface IPageSetupBase

setCenterHorizontally

public void setCenterHorizontally(boolean value)

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

Specified by:

setCenterHorizontally in interface IPageSetupBase

getCenterVertically

public boolean getCenterVertically()

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

Specified by:

getCenterVertically in interface IPageSetupBase

setCenterVertically

public void setCenterVertically(boolean value)

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

Specified by:

setCenterVertically in interface IPageSetupBase

getCopies

public int getCopies()

Number of copies to print.

Specified by:

getCopies in interface IPageSetupBase

setCopies

public void setCopies(int value)

Number of copies to print.

Specified by:

setCopies in interface IPageSetupBase

getDraft

public boolean getDraft()

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

Specified by:

getDraft in interface IPageSetupBase

setDraft

public void setDraft(boolean value)

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

Specified by:

setDraft in interface IPageSetupBase

getFirstPageNumber

public int getFirstPageNumber()

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.

Specified by:

getFirstPageNumber in interface IPageSetupBase

setFirstPageNumber

public void setFirstPageNumber(int value)

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.

Specified by:

setFirstPageNumber in interface IPageSetupBase

getFooterMarginInch

public double getFooterMarginInch()

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

Specified by:

getFooterMarginInch in interface IPageSetupBase

setFooterMarginInch

public void setFooterMarginInch(double value)

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

Specified by:

setFooterMarginInch in interface IPageSetupBase

getFitToPagesTall

public int getFitToPagesTall()

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.

setFitToPagesTall

public void setFitToPagesTall(int value)

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.

getFitToPagesWide

public int getFitToPagesWide()

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.

setFitToPagesWide

public void setFitToPagesWide(int value)

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.

getHeaderMarginInch

public double getHeaderMarginInch()

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

Specified by:

getHeaderMarginInch in interface IPageSetupBase

setHeaderMarginInch

public void setHeaderMarginInch(double value)

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

Specified by:

setHeaderMarginInch in interface IPageSetupBase

getHResolution

public int getHResolution()

Gets or sets horizontal resolution in dpi.

setHResolution

public void setHResolution(int value)

Gets or sets horizontal resolution in dpi.

getFullHeaderString

public java.lang.String getFullHeaderString()

Represents full header string. Read only.

setFullHeaderString

public void setFullHeaderString(java.lang.String value)

Represents full header string. Read only.

getFullFooterString

public java.lang.String getFullFooterString()

Gets footer full string. Read only.

setFullFooterString

public void setFullFooterString(java.lang.String value)

Gets footer full string. Read only.

getFirstHeaderString

public java.lang.String getFirstHeaderString()

Represents first page header string. Read only.

setFirstHeaderString

public void setFirstHeaderString(java.lang.String value)

Represents first page header string. Read only.

getFirstFooterString

public java.lang.String getFirstFooterString()

Gets first page footer string. Read only.

setFirstFooterString

public void setFirstFooterString(java.lang.String value)

Gets first page footer string. Read only.

getOddHeaderString

public java.lang.String getOddHeaderString()

Gets Odd page header string. Read only.

setOddHeaderString

public void setOddHeaderString(java.lang.String oddHeaderString)

Sets odd page header string. Read only.

getOddFooterString

public java.lang.String getOddFooterString()

Gets Odd page footer string. Read only.

setOddFooterString

public void setOddFooterString(java.lang.String oddFooterString)

Sets odd page footer string. Read only.

getEvenHeaderString

public java.lang.String getEvenHeaderString()

Gets Even page header string. Read only.

setEvenHeaderString

public void setEvenHeaderString(java.lang.String evenHeaderString)

Sets even page header string. Read only.

getEvenFooterString

public java.lang.String getEvenFooterString()

Gets OddEven page footer string. Read only.

setEvenFooterString

public void setEvenFooterString(java.lang.String evenFooterString)

Sets odd even page footer string. Read only.

getAlignWithMargins

public byte getAlignWithMargins()

Indicates whether align header footer margins with page margins.Default value is 1

setAlignWithMargins

public void setAlignWithMargins(byte value)

Indicates whether align header footer margins with page margins.Default value is 1

getDifferentOddEven

public byte getDifferentOddEven()

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

setDifferentOddEven

public void setDifferentOddEven(byte differentOddEven)

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

getScaleWithDoc

public byte getScaleWithDoc()

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

setScaleWithDoc

public void setScaleWithDoc(byte value)

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

getDifferentFirst

public byte getDifferentFirst()

Indicates whether different first page header and footer.Default value is 0

setDifferentFirst

public void setDifferentFirst(byte value)

Indicates whether different first page header and footer.Default value is 0

getVResolution

public int getVResolution()

Gets vertical resolution in dpi.

setVResolution

public void setVResolution(int value)

Sets vertical resolution in dpi.

getLeftFooter

public java.lang.String getLeftFooter()

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.

Specified by:

getLeftFooter in interface IPageSetupBase

setLeftFooter

public void setLeftFooter(java.lang.String value)

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.

Specified by:

setLeftFooter in interface IPageSetupBase

getLeftFooterImage

public java.awt.image.BufferedImage getLeftFooterImage()

Gets / set image for left part of the footer.

Specified by:

getLeftFooterImage in interface IPageSetupBase

Returns:

setLeftFooterImage

public void setLeftFooterImage(java.awt.image.BufferedImage value)

set image for left part of the footer.

Specified by:

setLeftFooterImage in interface IPageSetupBase

Parameters:

value -

getLeftHeader

public java.lang.String getLeftHeader()

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

Specified by:

getLeftHeader in interface IPageSetupBase

setLeftHeader

public void setLeftHeader(java.lang.String leftHeader)

Sets the left part of the header. Write string.

Specified by:

setLeftHeader in interface IPageSetupBase

getLeftHeaderImage

public java.awt.image.BufferedImage getLeftHeaderImage()

Gets / set image for left part of the header.

Specified by:

getLeftHeaderImage in interface IPageSetupBase

Returns:

setLeftHeaderImage

public void setLeftHeaderImage(java.awt.image.BufferedImage bufferedImage)

Sets image for left part of the header.

Specified by:

setLeftHeaderImage in interface IPageSetupBase

Parameters:

bufferedImage -

setLeftHeaderImage

public void setLeftHeaderImage(java.awt.image.BufferedImage bufferedImage,
                               float scale)

Sets image for left part of the header.

Parameters:

bufferedImage -

scale -

getLeftMargin

public double getLeftMargin()

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

Specified by:

getLeftMargin in interface IPageSetupBase

setLeftMargin

public void setLeftMargin(double leftMargin)

Sets the value of the left margin, in inches. Write double.

Specified by:

setLeftMargin in interface IPageSetupBase

getOrder

public OrderType getOrder()

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

Specified by:

getOrder in interface IPageSetupBase

setOrder

public void setOrder(OrderType value)

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

Specified by:

setOrder in interface IPageSetupBase

getOrientation

public PageOrientationType getOrientation()

Portrait or landscape printing mode. Read / write ExcelPageOrientation

Specified by:

getOrientation in interface IPageSetupBase

setOrientation

public void setOrientation(PageOrientationType orientation)

Sets portrait or landscape printing mode. Write excel page orientation

Specified by:

setOrientation in interface IPageSetupBase

getPaperSize

public PaperSizeType getPaperSize()

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

Specified by:

getPaperSize in interface IPageSetupBase

setPaperSize

public void setPaperSize(PaperSizeType paperSize)

Sets the size of the paper. Write excel paper size.

Specified by:

setPaperSize in interface IPageSetupBase

getPrintComments

public PrintCommentType getPrintComments()

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

Specified by:

getPrintComments in interface IPageSetupBase

setPrintComments

public void setPrintComments(PrintCommentType value)

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

Specified by:

setPrintComments in interface IPageSetupBase

getPrintErrors

public PrintErrorsType getPrintErrors()

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.

Specified by:

getPrintErrors in interface IPageSetupBase

setPrintErrors

public void setPrintErrors(PrintErrorsType value)

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.

Specified by:

setPrintErrors in interface IPageSetupBase

getRightFooter

public java.lang.String getRightFooter()

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

Specified by:

getRightFooter in interface IPageSetupBase

setRightFooter

public void setRightFooter(java.lang.String value)

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

Specified by:

setRightFooter in interface IPageSetupBase

getRightFooterImage

public java.awt.image.BufferedImage getRightFooterImage()

Gets / set image for right part of the footer.

Specified by:

getRightFooterImage in interface IPageSetupBase

Returns:

setRightFooterImage

public void setRightFooterImage(java.awt.image.BufferedImage image)

set image for right part of the footer.

Specified by:

setRightFooterImage in interface IPageSetupBase

Parameters:

image -

getRightHeader

public java.lang.String getRightHeader()

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

Specified by:

getRightHeader in interface IPageSetupBase

setRightHeader

public void setRightHeader(java.lang.String value)

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

Specified by:

setRightHeader in interface IPageSetupBase

getRightHeaderImage

public java.awt.image.BufferedImage getRightHeaderImage()

Gets / set image for right part of the header.

Specified by:

getRightHeaderImage in interface IPageSetupBase

Returns:

setRightHeaderImage

public void setRightHeaderImage(java.awt.image.BufferedImage bufferedImage)

set image for right part of the header.

Specified by:

setRightHeaderImage in interface IPageSetupBase

Parameters:

bufferedImage -

setRightHeaderImage

public void setRightHeaderImage(java.awt.image.BufferedImage bufferedImage,
                                float scale)

set image for right part of the header.

Parameters:

bufferedImage -

scale -

getRightMargin

public double getRightMargin()

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

Specified by:

getRightMargin in interface IPageSetupBase

setRightMargin

public void setRightMargin(double rightMargin)

Sets the size of the right margin, in inches. Write double.

Specified by:

setRightMargin in interface IPageSetupBase

getTopMargin

public double getTopMargin()

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

Specified by:

getTopMargin in interface IPageSetupBase

setTopMargin

public void setTopMargin(double topMargin)

Sets the size of the top margin, in inches. Write double.

Specified by:

setTopMargin in interface IPageSetupBase

getZoom

public int getZoom()

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

Specified by:

getZoom in interface IPageSetupBase

setZoom

public void setZoom(int value)

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.

Specified by:

setZoom in interface IPageSetupBase

getCenterFooterPictureWidth

public int getCenterFooterPictureWidth()

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

setCenterFooterPictureWidth

public void setCenterFooterPictureWidth(int value)

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

getCenterFooterPictureHeight

public int getCenterFooterPictureHeight()

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

setCenterFooterPictureHeight

public void setCenterFooterPictureHeight(int value)

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

getCenterHeaderPictureWidth

public int getCenterHeaderPictureWidth()

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

setCenterHeaderPictureWidth

public void setCenterHeaderPictureWidth(int value)

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

getCenterHeaderPictureHeight

public int getCenterHeaderPictureHeight()

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

setCenterHeaderPictureHeight

public void setCenterHeaderPictureHeight(int value)

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

getLeftFooterPictureWidth

public int getLeftFooterPictureWidth()

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

setLeftFooterPictureWidth

public void setLeftFooterPictureWidth(int value)

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

getLeftFooterPictureHeight

public int getLeftFooterPictureHeight()

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

setLeftFooterPictureHeight

public void setLeftFooterPictureHeight(int value)

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

getLeftHeaderPictureWidth

public int getLeftHeaderPictureWidth()

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

setLeftHeaderPictureWidth

public void setLeftHeaderPictureWidth(int value)

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

getLeftHeaderPictureHeight

public int getLeftHeaderPictureHeight()

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

setLeftHeaderPictureHeight

public void setLeftHeaderPictureHeight(int value)

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

getRightFooterPictureWidth

public int getRightFooterPictureWidth()

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

setRightFooterPictureWidth

public void setRightFooterPictureWidth(int value)

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

getRightFooterPictureHeight

public int getRightFooterPictureHeight()

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

setRightFooterPictureHeight

public void setRightFooterPictureHeight(int value)

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

getRightHeaderPictureWidth

public int getRightHeaderPictureWidth()

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

setRightHeaderPictureWidth

public void setRightHeaderPictureWidth(int value)

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

getRightHeaderPictureHeight

public int getRightHeaderPictureHeight()

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

setRightHeaderPictureHeight

public void setRightHeaderPictureHeight(int value)

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

getBackgoundImage

public java.awt.image.BufferedImage getBackgoundImage()

Gets / sets background image.

setBackgoundImage

public void setBackgoundImage(java.awt.image.BufferedImage image)

Gets / sets background image.

Parameters:

image -

getPageWidth

public double getPageWidth()

Returns page width in points. Read-only.

getPageHeight

public double getPageHeight()

Returns page width in points. Read-only.