Document Solutions for Excel, .NET Edition | Document Solutions
GrapeCity.Documents.Excel Namespace / IPageSetup Interface
Properties Methods

In This Topic
    IPageSetup Interface Members
    In This Topic

    The following tables list the members exposed by IPageSetup.

    Public Properties
     NameDescription
     Property Returns True to align the header and the footer with the margins set in the page setup options.  
     Property Gets or 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.  
     Property Gets or 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.  
     Property True if elements of the document will be printed in black and white.  
     Property Returns or sets the size of the bottom margin, in points.  
     Property Center aligns the footer information in the PageSetup object.  
     PropertyReturns a IGraphic object that represents the picture for the center section of the footer. Used to set attributes about the picture.  
     Property Center aligns the header information in the PageSetup object.  
     PropertyReturns a IGraphic object that represents the picture for the center section of the header. Used to set attributes about the picture.  
     Property True if the sheet is centered horizontally on the page when it's printed.  
     Property True if the sheet is centered vertically on the page when it's printed.  
     Property True if a different header or footer is used on the first page.  
     Property True if the sheet will be printed without graphics.  
     PropertyReturns the alignment of text on the even IPage of a workbook or section.  
     PropertyReturns the alignment of text on the first IPage of a workbook or section.  
     Property Returns or sets 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.  
     Property Returns or sets the number of pages tall the worksheet will be scaled to when it's printed. Applies only to worksheets.  
     Property Returns or sets the number of pages wide the worksheet will be scaled to when it's printed. Applies only to worksheets.  
     Property Returns or sets the size of the footer margin, in points.  
     Property Returns or sets the size of the header margin, in points.  
     Property Represents whether the first page number is automatically assigned. The default is true. When the first page number is specified, it would be set to false.  
     Property If this property is False, the FitToPagesWide and FitToPagesTall properties control how the worksheet is scaled.  
     Property Returns or sets the alignment of text on the left footer of a workbook or section.  
     PropertyReturns a IGraphic object that represents the picture for the left section of the footer. Used to set attributes about the picture.  
     Property Returns or sets the alignment of text on the left header of a workbook or section.  
     PropertyReturns a IGraphic object that represents the picture for the left section of the header. Used to set attributes about the picture.  
     Property Returns or sets the size of the left margin, in points.  
     Property True if the specified PageSetup object has different headers and footers for odd-numbered and even-numbered pages.  
     PropertyReturns or sets a Order value that represents the order uses to number pages when printing a large worksheet.  
     PropertyReturns or sets a PageOrientation value that represents the portrait or landscape printing mode.  
     Property Represents the height in inches of the paper, considered page orientation.  
     Property Returns or sets the size of the paper.  
     Property Represents the width in inches of the paper, considered page orientation.  
     Property Returns or sets the range to be printed, as a string using A1-style references in the language of the macro.  
     Property Returns or sets the way comments are printed with the sheet.  
     Property Gets or sets number of copies to print.  
     Property Returns or 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.  
     Property True if cell gridlines are printed on the page. Applies only to worksheets.  
     Property True if row and column headings are printed with this page. Applies only to worksheets.  
     Property True if cell notes are printed as end notes with the sheet. Applies only to worksheets.  
     Property Gets or 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".  
     PropertyReturns or sets a PrintQuality value that represents the print quality of this page. Default is 600 dpi.  
     Property Returns or 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.  
     Property Returns or sets the rows that contain the cells to be repeated at the bottom of each page, as a string in A1-style notation in the language of the macro.  
     Property 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.  
     Property 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.  
     Property Returns or sets the distance (in points) between the right edge of the page and the right boundary of the footer.  
     PropertyReturns a IGraphic object that represents the picture for the right section of the footer. Used to set attributes of the picture.  
     Property Returns or sets the right part of the header.  
     PropertyReturns a IGraphic object that represents the picture for the right section of the header. Used to set attributes of the picture.  
     Property Returns or sets the size of the right margin, in points.  
     Property Returns or sets if the header and footer should be scaled with the document when the size of the document changes.  
     Property Returns or sets the size of the top margin, in points.  
     Property Returns or sets a Variant value that represents a percentage (between 10 and 400 percent) by which Document Solutions for Excel will scale the worksheet for printing.  
    Top
    Public Methods
     NameDescription
     Method Sets the custom paper size, in unit of inches.  
     Method Generate page setup from the JSON string.  
     Method Generate the JSON string from page setup.  
    Top
    See Also