Skip to main content
A newer version of this page is available. .
.NET Framework 4.5.2+
Row

WorksheetPrintOptions Properties

Contains options used for printing a worksheet.
Name Description
AutoPageBreaks Gets or sets whether to position page breaks automatically.
BlackAndWhite Gets or sets whether to print the worksheet in black and white or in color.
CenterHorizontally Gets or sets whether worksheet data is centered horizontally on a printed page.
CenterVertically Gets or sets whether worksheet data is centered vertically on a printed page.
CommentsPrintMode Gets or sets how comments contained in the worksheet are printed.
Draft Gets or sets a value indicating whether to print the worksheet without graphics.
ErrorsPrintMode Gets or sets how errors contained in worksheet cells are printed.
FitToHeight Gets or sets the number of pages by height in which the worksheet shall fit when printed.
FitToPage Indicates whether the worksheet content is scaled to fit to a specific number of pages.
FitToWidth Gets or sets the number of pages in width to which the worksheet must fit when printed.
NumberOfCopies Gets or sets the number of worksheet copies to print.
PageNumbering Provides access to an object specifying page numbering options for the current worksheet.
PageOrder Gets or sets the order in which worksheet pages are numbered and printed.
PrintGridlines Gets or sets whether worksheet gridlines are printed.
PrintHeadings Gets or sets whether row and column headings are printed.
PrintTitles Provides access to an object used to specify rows and columns to be repeated on every printed page.
Scale Gets or sets the percentage by which to scale the worksheet content.
See Also