| | Name | Description |
|---|
 | customPaperSize | Sets the custom paper size, in unit of inches. |
| fromJson | Generate the page setup from the json. |
| getAlignMarginsHeaderFooter | Gets True to align the header and the footer with the margins set in the page setup options. |
| getBestFitColumns | Gets whether column widths are adjusted to fit the longest text width for printing. |
| getBestFitRows | Gets whether row heights are adjusted to fit the tallest text height for printing. |
| getBlackAndWhite | True if elements of the document will be printed in black and white. |
| getBottomMargin | Gets the size of the bottom margin, in points. |
| getCenterFooter | Center aligns the footer information in the PageSetup object. |
| getCenterFooterPicture | Gets a IGraphic object that represents the picture for the centersection of the footer. Used to set attributes about the picture. |
| getCenterHeader | Center aligns the header information in the PageSetup object. |
| getCenterHeaderPicture | Gets a IGraphic object that represents the picture for the centersection of the header. Used to set attributes about the picture. |
| getCenterHorizontally | True if the sheet is centered horizontally on the page when it's printed. |
| getCenterVertically | True if the sheet is centered vertically on the page when it's printed. |
| getDifferentFirstPageHeaderFooter | True if a different header or footer is used on the first page. |
| getDraft | True if the sheet will be printed without graphics. |
| getEvenPage | Gets the alignment of text on the even IPage of a workbook orsection. |
| getFirstPage | Gets the alignment of text on the first IPage of a workbook orsection. |
| getFirstPageNumber | Gets the first page number that will be used when this sheet is printed. If Automatic, GcExcel chooses the first page number. The default is Automatic. |
| getFitToPagesTall | Gets the number of pages tall the worksheet will be scaled to when it's printed. Applies only to worksheets. |
| getFitToPagesWide | Gets the number of pages wide the worksheet will be scaled to when it's printed. Applies only to worksheets. |
| getFooterMargin | Gets the size of the footer margin, in points. |
| getHeaderMargin | Gets the size of the header margin, in points. |
| getIsPercentScale | If this property is False, the FitToPagesWide and FitToPagesTall properties control how the worksheet is scaled. |
| getLeftFooter | Gets the alignment of text on the left footer of a workbook or section. |
| getLeftFooterPicture | Gets a IGraphic object that represents the picture for the leftsection of the footer. Used to set attributes about the picture. |
| getLeftHeader | Gets the alignment of text on the left header of a workbook or section. |
| getLeftHeaderPicture | Gets a IGraphic object that represents the picture for the leftsection of the header. Used to set attributes about the picture. |
| getLeftMargin | Gets the size of the left margin, in points. |
| getOddAndEvenPagesHeaderFooter | True if the specified PageSetup object has different headers and footers for odd-numbered and even-numbered pages. |
| getOrder | Gets a Order value that represents the order that GcExceluses to number pages when printing a large worksheet. |
| getOrientation | Gets a PageOrientation value that represents the portrait orlandscape printing mode. |
| getPaperHeight | Represents the height in inches of the paper, considered page orientation. |
| getPaperSize | Gets the size of the paper. |
| getPaperWidth | Represents the width in inches of the paper, considered page orientation. |
| getPrintArea | Gets the range to be printed, as a string using A1-style references in the language of the macro. |
| getPrintComments | Gets the way comments are printed with the sheet. |
| getPrintCopies | Gets number of copies to print. |
| getPrintErrors | Gets 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. |
| getPrintGridlines | True if cell gridlines are printed on the page. Applies only to worksheets. |
| getPrintHeadings | True if row and column headings are printed with this page. Applies only to worksheets. |
| getPrintNotes | True if cell notes are printed as end notes with the sheet. Applies only to worksheets. |
| getPrintPageRange | Gets 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". |
| getPrintQuality | Gets a PrintQuality value that represents the print quality ofthis page. Default is 600 dpi. |
| getPrintTailColumns | Gets 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. |
| getPrintTailRows | Gets 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. |
| getPrintTitleColumns | Gets 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. |
| getPrintTitleRows | Gets 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. |
| getRightFooter | Gets the distance (in points) between the right edge of the page and the right boundary of the footer. |
| getRightFooterPicture | Gets a IGraphic object that represents the picture for the rightsection of the footer. Used to set attributes of the picture. |
| getRightHeader | Gets the right part of the header. |
| getRightHeaderPicture | Gets a IGraphic object that represents the picture for the rightsection of the header. Used to set attributes of the picture. |
| getRightMargin | Gets the size of the right margin, in points. |
| getScaleWithDocHeaderFooter | Gets if the header and footer should be scaled with the document when the size of the document changes. |
| getTopMargin | Gets the size of the top margin, in points. |
| getZoom | Gets a Variant value that represents a percentage (between 10 and 400 percent) by which GcExcel will scale the worksheet for printing. |
| setAlignMarginsHeaderFooter | Gets True to align the header and the footer with the margins set in the page setup options. |
| setBestFitColumns | Sets 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. |
| setBestFitRows | Sets 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. |
| setBlackAndWhite | True if elements of the document will be printed in black and white. |
| setBottomMargin | Sets the size of the bottom margin, in points. |
| setCenterFooter | Center aligns the footer information in the PageSetup object. |
| setCenterHeader | Center aligns the header information in the PageSetup object. |
| setCenterHorizontally | True if the sheet is centered horizontally on the page when it's printed. |
| setCenterVertically | True if the sheet is centered vertically on the page when it's printed. |
| setDifferentFirstPageHeaderFooter | True if a different header or footer is used on the first page. |
| setDraft | True if the sheet will be printed without graphics. |
| setFirstPageNumber | Sets the first page number that will be used when this sheet is printed. If Automatic, GcExcel chooses the first page number. The default is Automatic. |
| setFitToPagesTall | Sets the number of pages tall the worksheet will be scaled to when it's printed. Applies only to worksheets. |
| setFitToPagesWide | Sets the number of pages wide the worksheet will be scaled to when it's printed. Applies only to worksheets. |
| setFooterMargin | Sets the size of the footer margin, in points. |
| setHeaderMargin | Sets the size of the header margin, in points. |
| setIsPercentScale | If this property is False, the FitToPagesWide and FitToPagesTall properties control how the worksheet is scaled. |
| setLeftFooter | Sets the alignment of text on the left footer of a workbook or section. |
| setLeftHeader | Sets the alignment of text on the left header of a workbook or section. |
| setLeftMargin | Sets the size of the left margin, in points. |
| setOddAndEvenPagesHeaderFooter | True if the specified PageSetup object has different headers and footers for odd-numbered and even-numbered pages. |
| setOrder | Sets a Order value that represents the order that GcExceluses to number pages when printing a large worksheet. |
| setOrientation | Sets a PageOrientation value that represents the portrait orlandscape printing mode. |
| setPaperSize | Sets the size of the paper. |
| setPrintArea | Sets the range to be printed, as a string using A1-style references in the language of the macro. |
| setPrintComments | Sets the way comments are printed with the sheet. |
| setPrintCopies | Sets number of copies to print. |
| setPrintErrors | Sets 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. |
| setPrintGridlines | True if cell gridlines are printed on the page. Applies only to worksheets. |
| setPrintHeadings | True if row and column headings are printed with this page. Applies only to worksheets. |
| setPrintNotes | True if cell notes are printed as end notes with the sheet. Applies only to worksheets. |
| setPrintPageRange | Sets 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". |
| setPrintQuality | Sets a PrintQuality value that represents the print quality of thispage. Default is 600 dpi. |
| setPrintTailColumns | Sets 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. |
| setPrintTailRows | Sets 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. |
| setPrintTitleColumns | 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. |
| setPrintTitleRows | 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. |
| setRightFooter | Sets the distance (in points) between the right edge of the page and the right boundary of the footer. |
| setRightHeader | Sets the right part of the header. |
| setRightMargin | Sets the size of the right margin, in points. |
| setScaleWithDocHeaderFooter | Sets if the header and footer should be scaled with the document when the size of the document changes. |
| setTopMargin | Sets the size of the top margin, in points. |
| setZoom | Sets a Variant value that represents a percentage (between 10 and 400 percent) by which GcExcel will scale the worksheet for printing. |
| toJson | Generate the json from page setup. |