DS.Documents.Excel Assembly

GrapeCity.Documents.Excel.IPageSetup

IPageSetup Interface

Represents the page setup description.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public interface IPageSetup

Public Interface IPageSetup

Properties

Name	Description
AlignMarginsHeaderFooter	Returns True to align the header and the footer with the margins set in the page setup options.
BestFitColumns	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.
BestFitRows	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.
BlackAndWhite	True if elements of the document will be printed in black and white.
BottomMargin	Returns or sets the size of the bottom margin, in points.
CenterFooter	Center aligns the footer information in the PageSetup object.
CenterFooterPicture	Returns a IGraphic object that represents the picture for the center section of the footer. Used to set attributes about the picture.
CenterHeader	Center aligns the header information in the PageSetup object.
CenterHeaderPicture	Returns a IGraphic object that represents the picture for the center section of the header. Used to set attributes about the picture.
CenterHorizontally	True if the sheet is centered horizontally on the page when it's printed.
CenterVertically	True if the sheet is centered vertically on the page when it's printed.
DifferentFirstPageHeaderFooter	True if a different header or footer is used on the first page.
Draft	True if the sheet will be printed without graphics.
EvenPage	Returns the alignment of text on the even IPage of a workbook or section.
FirstPage	Returns the alignment of text on the first IPage of a workbook or section.
FirstPageNumber	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.
FitToPagesTall	Returns or sets the number of pages tall the worksheet will be scaled to when it's printed. Applies only to worksheets.
FitToPagesWide	Returns or sets the number of pages wide the worksheet will be scaled to when it's printed. Applies only to worksheets.
FooterMargin	Returns or sets the size of the footer margin, in points.
HeaderMargin	Returns or sets the size of the header margin, in points.
IsAutoFirstPageNumber	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.
IsPercentScale	If this property is False, the FitToPagesWide and FitToPagesTall properties control how the worksheet is scaled.
LeftFooter	Returns or sets the alignment of text on the left footer of a workbook or section.
LeftFooterPicture	Returns a IGraphic object that represents the picture for the left section of the footer. Used to set attributes about the picture.
LeftHeader	Returns or sets the alignment of text on the left header of a workbook or section.
LeftHeaderPicture	Returns a IGraphic object that represents the picture for the left section of the header. Used to set attributes about the picture.
LeftMargin	Returns or sets the size of the left margin, in points.
OddAndEvenPagesHeaderFooter	True if the specified PageSetup object has different headers and footers for odd-numbered and even-numbered pages.
Order	Returns or sets a Order value that represents the order uses to number pages when printing a large worksheet.
Orientation	Returns or sets a PageOrientation value that represents the portrait or landscape printing mode.
PaperHeight	Represents the height in inches of the paper, considered page orientation.
PaperSize	Returns or sets the size of the paper.
PaperWidth	Represents the width in inches of the paper, considered page orientation.
PrintArea	Returns or sets the range to be printed, as a string using A1-style references in the language of the macro.
PrintComments	Returns or sets the way comments are printed with the sheet.
PrintCopies	Gets or sets number of copies to print.
PrintErrors	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.
PrintGridlines	True if cell gridlines are printed on the page. Applies only to worksheets.
PrintHeadings	True if row and column headings are printed with this page. Applies only to worksheets.
PrintNotes	True if cell notes are printed as end notes with the sheet. Applies only to worksheets.
PrintPageRange	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".
PrintQuality	Returns or sets a PrintQuality value that represents the print quality of this page. Default is 600 dpi.
PrintTailColumns	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.
PrintTailRows	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.
PrintTitleColumns	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.
PrintTitleRows	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.
RightFooter	Returns or sets the distance (in points) between the right edge of the page and the right boundary of the footer.
RightFooterPicture	Returns a IGraphic object that represents the picture for the right section of the footer. Used to set attributes of the picture.
RightHeader	Returns or sets the right part of the header.
RightHeaderPicture	Returns a IGraphic object that represents the picture for the right section of the header. Used to set attributes of the picture.
RightMargin	Returns or sets the size of the right margin, in points.
ScaleWithDocHeaderFooter	Returns or sets if the header and footer should be scaled with the document when the size of the document changes.
TopMargin	Returns or sets the size of the top margin, in points.
Zoom	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.

Methods

Name	Description
CustomPaperSize(double, double)	Sets the custom paper size, in unit of inches.
FromJson(string)	Generate page setup from the JSON string.
ToJson()	Generate the JSON string from page setup.

IPageSetup Interface
Namespace: GrapeCity.Documents.Excel
Assembly: DS.Documents.Excel.dll
Syntax
Properties
Methods