TExportPageSettings

Description

TExportPageSettings stores the print page settings of a worksheet.

Properties

NameTypeDescription
MarginLeftDoubleLeft margin of the page in centimeters.
MarginTopDoubleTop margin of the page in centimeters.
MarginRightDoubleRight margin of the page in centimeters.
MarginBottomDoubleBottom margin of the page in centimeters.
CenterTableTExportCenterTable Defines if the table will be centered on the print page. Use a set of these parameters:
  • ectHorizontal: center horizontally
  • ectVertical: center vertically
PageOrientationTPrinterOrientation Defines the page orientation:
  • poPortrait: portrait
  • poLandscape: landscape
PageOrderTExportFlowOrientation Defines the table flow if the table is bigger than one page:
  • efoLeftToRight: left-to-right then top-to-bottom.
  • efoTopToBottom: top-to-bottom then left-to-right.
FirstPageNumberInteger The number of the first page in the sheet. XLS and XLSX support even negative page numbers, ODS supports only numbers greater than 1.
PrintRangeTExportRange Table print range. If a valid range is specified, only the cells defined by the range will be printed. Valid range must have defined a rectangle area (both left/right columns and top/bottom rows must be defined).
RowsToRepeatTExportRange Row range that will be printed on top of every page. Useful for table header. Only row range is used.
ColsToRepeatTExportRange Column range that will be printed on left side of every page. Useful for table header. Only column range is used.
PrintHeadersBooleanPrint column and row headers.
PrintGridLinesBooleanPrint grid lines.
ScaleTypeTExportScaleTypeestPercent: PrintScale is used
estFitToPage: FitWidthToPages and FitHeightToPages are used.
PrintScaleIntegerPrint scale in percent. 100 means no scaling (100%). Check the ScaleType property as well.
FitWidthToPagesIntegerThe document's width will be scaled to this count of pages. 0 means no scaling used. Check the ScaleType property as well.
FitHeightToPagesIntegerThe document's height will be scaled to this count of pages. 0 means no scaling used. Check the ScaleType property as well.
Code snippet: Custom table header in big tables.
Categories