Document Solutions for Excel, Java Edition | Document Solutions
com.grapecity.documents.excel Package / IPageSetup Interface
Methods

In This Topic
    IPageSetup Interface Members
    In This Topic

    The following tables list the members exposed by IPageSetup.

    Public Methods
     NameDescription
     MethodSets the custom paper size, in unit of inches.  
     MethodGenerate the page setup from the json.  
     MethodGets True to align the header and the footer with the margins set in the page setup options.  
     MethodGets whether column widths are adjusted to fit the longest text width for printing.  
     MethodGets whether row heights are adjusted to fit the tallest text height for printing.  
     MethodTrue if elements of the document will be printed in black and white.  
     MethodGets the size of the bottom margin, in points.  
     MethodCenter aligns the footer information in the PageSetup object.  
     MethodGets a IGraphic object that represents the picture for the centersection of the footer. Used to set attributes about the picture.  
     MethodCenter aligns the header information in the PageSetup object.  
     MethodGets a IGraphic object that represents the picture for the centersection of the header. Used to set attributes about the picture.  
     MethodTrue if the sheet is centered horizontally on the page when it's printed.  
     MethodTrue if the sheet is centered vertically on the page when it's printed.  
     MethodTrue if a different header or footer is used on the first page.  
     MethodTrue if the sheet will be printed without graphics.  
     MethodGets the alignment of text on the even IPage of a workbook orsection.  
     MethodGets the alignment of text on the first IPage of a workbook orsection.  
     MethodGets the first page number that will be used when this sheet is printed. If Automatic, Document Solutions for Excel chooses the first page number. The default is Automatic.  
     MethodGets the number of pages tall the worksheet will be scaled to when it's printed. Applies only to worksheets.  
     MethodGets the number of pages wide the worksheet will be scaled to when it's printed. Applies only to worksheets.  
     MethodGets the size of the footer margin, in points.  
     MethodGets the size of the header margin, in points.  
     MethodGets whether the first page number is automatically assigned. The default is true. When the first page number is specified, it returns false.  
     MethodIf this property is False, the FitToPagesWide and FitToPagesTall properties control how the worksheet is scaled.  
     MethodGets the alignment of text on the left footer of a workbook or section.  
     MethodGets a IGraphic object that represents the picture for the leftsection of the footer. Used to set attributes about the picture.  
     MethodGets the alignment of text on the left header of a workbook or section.  
     MethodGets a IGraphic object that represents the picture for the leftsection of the header. Used to set attributes about the picture.  
     MethodGets the size of the left margin, in points.  
     MethodTrue if the specified PageSetup object has different headers and footers for odd-numbered and even-numbered pages.  
     MethodGets a Order value that represents the orderuses to number pages when printing a large worksheet.  
     MethodGets a PageOrientation value that represents the portrait orlandscape printing mode.  
     MethodRepresents the height in inches of the paper, considered page orientation.  
     MethodGets the size of the paper.  
     MethodRepresents the width in inches of the paper, considered page orientation.  
     MethodGets the range to be printed, as a string using A1-style references in the language of the macro.  
     MethodGets the way comments are printed with the sheet.  
     MethodGets number of copies to print.  
     MethodGets an PrintErrors contstant specifying the type of print error displayed. This feature allows users to suppress the display of error values when printing a worksheet.  
     MethodTrue if cell gridlines are printed on the page. Applies only to worksheets.  
     MethodTrue if row and column headings are printed with this page. Applies only to worksheets.  
     MethodTrue if cell notes are printed as end notes with the sheet. Applies only to worksheets.  
     MethodGets range of pages to print, the numbers or page ranges are separated by commas counting from the beginning of the document. For example, type "1,3,5-12".  
     MethodGets a PrintQuality value that represents the print quality ofthis page. Default is 600 dpi.  
     MethodGets the columns that contain the cells to be repeated on the right side of each page, as a string in A1-style notation in the language of the macro.  
     MethodGets the rows that contain the cells to be repeated on the bottom of each page, as a string in A1-style notation in the language of the macro.  
     MethodGets 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.  
     MethodGets 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.  
     MethodGets the distance (in points) between the right edge of the page and the right boundary of the footer.  
     MethodGets a IGraphic object that represents the picture for the rightsection of the footer. Used to set attributes of the picture.  
     MethodGets the right part of the header.  
     MethodGets a IGraphic object that represents the picture for the rightsection of the header. Used to set attributes of the picture.  
     MethodGets the size of the right margin, in points.  
     MethodGets if the header and footer should be scaled with the document when the size of the document changes.  
     MethodGets the size of the top margin, in points.  
     MethodGets a Variant value that represents a percentage (between 10 and 400 percent) by which Document Solutions for Excel will scale the worksheet for printing.  
     MethodGets True to align the header and the footer with the margins set in the page setup options.  
     MethodSets whether column widths are adjusted to fit the longest text width for printing. May cause some efficiency problems if the file contains large amounts of data.  
     MethodSets whether row heights are adjusted to fit the tallest text height for printing. May cause some efficiency problems if the file contains large amounts of data.  
     MethodTrue if elements of the document will be printed in black and white.  
     MethodSets the size of the bottom margin, in points.  
     MethodCenter aligns the footer information in the PageSetup object.  
     MethodCenter aligns the header information in the PageSetup object.  
     MethodTrue if the sheet is centered horizontally on the page when it's printed.  
     MethodTrue if the sheet is centered vertically on the page when it's printed.  
     MethodTrue if a different header or footer is used on the first page.  
     MethodTrue if the sheet will be printed without graphics.  
     MethodSets the first page number that will be used when this sheet is printed. If Automatic, Document Solutions for Excel chooses the first page number. The default is Automatic.  
     MethodSets the number of pages tall the worksheet will be scaled to when it's printed. Applies only to worksheets.  
     MethodSets the number of pages wide the worksheet will be scaled to when it's printed. Applies only to worksheets.  
     MethodSets the size of the footer margin, in points.  
     MethodSets the size of the header margin, in points.  
     MethodSets whether the first page number is automatically assigned. The default is true.  
     MethodIf this property is False, the FitToPagesWide and FitToPagesTall properties control how the worksheet is scaled.  
     MethodSets the alignment of text on the left footer of a workbook or section.  
     MethodSets the alignment of text on the left header of a workbook or section.  
     MethodSets the size of the left margin, in points.  
     MethodTrue if the specified PageSetup object has different headers and footers for odd-numbered and even-numbered pages.  
     MethodSets a Order value that represents the orderuses to number pages when printing a large worksheet.  
     MethodSets a PageOrientation value that represents the portrait orlandscape printing mode.  
     MethodSets the size of the paper.  
     MethodSets the range to be printed, as a string using A1-style references in the language of the macro.  
     MethodSets the way comments are printed with the sheet.  
     MethodSets number of copies to print.  
     MethodSets an PrintErrors contstant specifying the type of print error displayed. This feature allows users to suppress the display of error values when printing a worksheet.  
     MethodTrue if cell gridlines are printed on the page. Applies only to worksheets.  
     MethodTrue if row and column headings are printed with this page. Applies only to worksheets.  
     MethodTrue if cell notes are printed as end notes with the sheet. Applies only to worksheets.  
     MethodSets range of pages to print, the numbers or page ranges are separated by commas counting from the beginning of the document. For example, type "1,3,5-12".  
     MethodSets a PrintQuality value that represents the print quality of thispage. Default is 600 dpi.  
     MethodSets the columns that contain the cells to be repeated on the right side of each page, as a string in A1-style notation in the language of the macro.  
     MethodSets the rows that contain the cells to be repeated on the bottom of each page, as a string in A1-style notation in the language of the macro.  
     MethodSets 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.  
     MethodSets 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.  
     MethodSets the distance (in points) between the right edge of the page and the right boundary of the footer.  
     MethodSets the right part of the header.  
     MethodSets the size of the right margin, in points.  
     MethodSets if the header and footer should be scaled with the document when the size of the document changes.  
     MethodSets the size of the top margin, in points.  
     MethodSets a Variant value that represents a percentage (between 10 and 400 percent) by which Document Solutions for Excel will scale the worksheet for printing.  
     MethodGenerate the json from page setup.  
    Top
    See Also