Class which exposes the various print options available for a worksheet which can be saved with both a worksheet and a custom view.
Inheritance
object
Properties
Section titled "Properties"AlignHeadersAndFootersWithMargins
Section titled "AlignHeadersAndFootersWithMargins"Inherited from: PrintOptionsBase
Gets or sets the value indicating whether to align header and footer margins with page margins.
public bool AlignHeadersAndFootersWithMargins { get; set; }BottomMargin
Section titled "BottomMargin"Inherited from: PrintOptionsBase
Gets or sets the margin at the bottom of each printed page of the worksheet, specified in inches.
public double BottomMargin { get; set; }DraftQuality
Section titled "DraftQuality"Inherited from: PrintOptionsBase
Gets or sets the value indicating whether the printed pages should be printed using draft quality.
public bool DraftQuality { get; set; }Footer
Section titled "Footer"Inherited from: PrintOptionsBase
Gets or sets the footer for each page of the printed worksheet.
public string Footer { get; set; }FooterMargin
Section titled "FooterMargin"Inherited from: PrintOptionsBase
Gets or sets the footer margin for each printed page of the worksheet, specified in inches.
public double FooterMargin { get; set; }Header
Section titled "Header"Inherited from: PrintOptionsBase
Gets or sets the header for each page of the printed worksheet.
public string Header { get; set; }HeaderMargin
Section titled "HeaderMargin"Inherited from: PrintOptionsBase
Gets or sets the header margin for each printed page of the worksheet, specified in inches.
public double HeaderMargin { get; set; }LeftMargin
Section titled "LeftMargin"Inherited from: PrintOptionsBase
Gets or sets the margin at the left of each printed page of the worksheet, specified in inches.
public double LeftMargin { get; set; }NumberOfCopies
Section titled "NumberOfCopies"Inherited from: PrintOptionsBase
Gets or sets the number of copies to print.
public int NumberOfCopies { get; set; }Orientation
Section titled "Orientation"Inherited from: PrintOptionsBase
Gets or sets the orientation for each page of the printed worksheet.
public Orientation Orientation { get; set; }OrientationResolved
Section titled "OrientationResolved"Inherited from: PrintOptionsBase
Returns the resolved orientation for each page of the printed worksheet.
public Orientation OrientationResolved { get; }PageNumbering
Section titled "PageNumbering"Inherited from: PrintOptionsBase
Gets or sets the method with which pages are numbered.
public PageNumbering PageNumbering { get; set; }PaperSize
Section titled "PaperSize"Inherited from: PrintOptionsBase
Gets or sets the paper size for each printed page of the worksheet.
public PaperSize PaperSize { get; set; }PrintErrors
Section titled "PrintErrors"Inherited from: PrintOptionsBase
Gets or sets the way error values of cells are printed.
public PrintErrors PrintErrors { get; set; }PrintInBlackAndWhite
Section titled "PrintInBlackAndWhite"Inherited from: PrintOptionsBase
Gets or sets the value indicating whether the worksheet should be printed in black and white.
public bool PrintInBlackAndWhite { get; set; }PrintNotes
Section titled "PrintNotes"Inherited from: PrintOptionsBase
Gets or sets the way cell comments are printed.
public PrintNotes PrintNotes { get; set; }Resolution
Section titled "Resolution"Inherited from: PrintOptionsBase
Gets or sets the horizontal print resolution in DPI.
public int Resolution { get; set; }RightMargin
Section titled "RightMargin"Inherited from: PrintOptionsBase
Gets or sets the margin at the right of each printed page of the worksheet, specified in inches.
public double RightMargin { get; set; }ScaleHeadersAndFootersWithDocument
Section titled "ScaleHeadersAndFootersWithDocument"Inherited from: PrintOptionsBase
Gets or sets the value indicating whether to scale the headers and footers with the document scaling.
public bool ScaleHeadersAndFootersWithDocument { get; set; }StartPageNumber
Section titled "StartPageNumber"Inherited from: PrintOptionsBase
Gets or sets the page number for the first printed page of the worksheet.
public int StartPageNumber { get; set; }TopMargin
Section titled "TopMargin"Inherited from: PrintOptionsBase
Gets or sets the margin at the top of each printed page of the worksheet, specified in inches.
public double TopMargin { get; set; }VerticalResolution
Section titled "VerticalResolution"Inherited from: PrintOptionsBase
Gets or sets the vertical print resolution in DPI.
public int VerticalResolution { get; set; }CenterHorizontally
Section titled "CenterHorizontally"Gets or sets the value indicating whether the printed pages should be centered horizontally.
public bool CenterHorizontally { get; set; }CenterVertically
Section titled "CenterVertically"Gets or sets the value indicating whether the printed pages should be centered vertically.
public bool CenterVertically { get; set; }ColumnsToRepeatAtLeft
Section titled "ColumnsToRepeatAtLeft"Gets or sets the range of columns which should be printed on every page.
public RepeatTitleRange ColumnsToRepeatAtLeft { get; set; }HorizontalPageBreaks
Section titled "HorizontalPageBreaks"Gets the collection of horizontal page breaks in the .
public HorizontalPageBreakCollection HorizontalPageBreaks { get; }MaxPagesHorizontally
Section titled "MaxPagesHorizontally"Gets or sets the maximum number of pages allowed in the horizontal direction to print the worksheet.
public int MaxPagesHorizontally { get; set; }MaxPagesVertically
Section titled "MaxPagesVertically"Gets or sets the maximum number of pages allowed in the vertical direction to print the worksheet.
public int MaxPagesVertically { get; set; }PageOrder
Section titled "PageOrder"Gets or sets the order in which to print pages for multiple page worksheets.
public PageOrder PageOrder { get; set; }PrintAreas
Section titled "PrintAreas"Gets the collection of print areas in the .
public PrintAreasCollection PrintAreas { get; }PrintGridlines
Section titled "PrintGridlines"Gets or sets the value which indicates whether to print the worksheet gridlines.
public bool PrintGridlines { get; set; }PrintRowAndColumnHeaders
Section titled "PrintRowAndColumnHeaders"Gets or sets the value indicating whether to print row and column headers.
public bool PrintRowAndColumnHeaders { get; set; }RowsToRepeatAtTop
Section titled "RowsToRepeatAtTop"Gets or sets the range of rows which should be printed on every page.
public RepeatTitleRange RowsToRepeatAtTop { get; set; }ScalingFactor
Section titled "ScalingFactor"Gets or sets the scaling factor to use when printing the worksheet.
public int ScalingFactor { get; set; }ScalingType
Section titled "ScalingType"Gets or sets the method for scaling the worksheet when it is printed.
public ScalingType ScalingType { get; set; }VerticalPageBreaks
Section titled "VerticalPageBreaks"Gets the collection of vertical page breaks in the .
public VerticalPageBreakCollection VerticalPageBreaks { get; }Methods
Section titled "Methods"ClearPageBreaks()
Section titled "ClearPageBreaks()"Clears all page breaks from the .
public void ClearPageBreaks()Returns any
InsertPageBreak(WorksheetCell)
Section titled "InsertPageBreak(WorksheetCell)"Inserts a horizontal and/or vertical page break before the specified cell.
public void InsertPageBreak(WorksheetCell cell)Parameters
- cell:
WorksheetCell
Returns any
InsertPageBreak(WorksheetColumn)
Section titled "InsertPageBreak(WorksheetColumn)"Inserts a vertical page break to the left of the specified column.
public void InsertPageBreak(WorksheetColumn column)Parameters
- column:
WorksheetColumn
Returns any
InsertPageBreak(WorksheetRow)
Section titled "InsertPageBreak(WorksheetRow)"Inserts a horizontal page break above the specified row.
public void InsertPageBreak(WorksheetRow row)Parameters
- row:
WorksheetRow
Returns any
Reset()
Section titled "Reset()"Resets the print options to their default settings.
public override void Reset()