-
dotnet-standard-api
-
C1.Excel Assembly
-
C1.Excel
-
Classes
- C1XLBook
- ShapeCollection
- XLBorderFormatting
- XLCell
- XLCellRange
- XLCellRangeCollection
- XLColumn
- XLColumnCollection
- XLComment
- XLCommentCollection
- XLCommentShape
- XLConditionalFormatting
- XLConditionalFormattingCollection
- XLConditionalFormattingRangeCollection
- XLConditionalFormattingRule
- XLConditionalFormattingRuleCollection
- XLDataValidation
- XLDataValidationCollection
- XLDataValidationRangeCollection
- XLExternalBook
- XLExternalBookCollection
- XLExternalSheet
- XLFont
- XLFontFormatting
- XLNamedRange
- XLNamedRangeCollection
- XLOpaqueShape
- XLPatternFormatting
- XLPictureShape
- XLPrintSettings
- XLProgressEventArgs
- XLRange
- XLRow
- XLRowCollection
- XLShape
- XLSheet
- XLSheetCollection
- XLStyle
- XLTextShape
- Structs
- Enums
- Delegates
-
Classes
- C1.Util
-
C1.Excel
-
C1.Excel Assembly
C1.Excel.XLPrintSettings
XLPrintSettings Class
Provides options and settings for printing XLSheet objects.
Implements
Namespace: C1.Excel
Assembly: C1.Excel.dll
Syntax
public class XLPrintSettings : ICloneableRemarks
<p>The settings are applied to each sheet and are accessible through the
sheet's PrintSettings property.
Note that C1XLBook does not provide any printing services. The settings are used when printing the sheet from Excel.
Constructors
| Name | Description |
|---|---|
| XLPrintSettings() | Creates a new instance of the XLPrintSettings class. |
Properties
| Name | Description |
|---|---|
| AlignWithMargins | Gets or sets the align header/footer with page margins used for printed output. |
| AutoScale | Gets or sets the scaling mode used for printed output. |
| BlackAndWhite | Gets or sets whether to print the sheet in monochrome mode. |
| CenterHorizontal | Gets or sets whether the sheet should be centered horizontally on the page when printed. |
| CenterVertical | Gets or sets whether the sheet should be centered vertically on the page when printed. |
| Copies | Gets or sets the number of copies to print. |
| DraftQuality | Gets or sets whether to print the sheet in draft quality mode. |
| FitPagesAcross | Fit the sheet to this number of pages across (0 means use as many as needed). |
| FitPagesDown | Fit the sheet to this number of pages down (0 means use as many as needed). |
| Footer | Gets or sets the string to be displayed as a page footer when the sheet is printed. |
| FooterEven | Gets or sets the string to be displayed as a even page footer when the sheet is printed. |
| FooterFirst | Gets or sets the string to be displayed as a first page footer when the sheet is printed. |
| FooterPictureCenter | Gets or sets the GrapeCity.Documents.Imaging.GcBitmap or XLPictureShape for the center part of the footer. |
| FooterPictureLeft | Gets or sets the GrapeCity.Documents.Imaging.GcBitmap or XLPictureShape for the left part of the footer. |
| FooterPictureRight | Gets or sets the GrapeCity.Documents.Imaging.GcBitmap or XLPictureShape for the right part of the footer. |
| Header | Gets or sets the string to be displayed as a page header when the sheet is printed. |
| HeaderEven | Gets or sets the string to be displayed as a even page header when the sheet is printed. |
| HeaderFirst | Gets or sets the string to be displayed as a first page header when the sheet is printed. |
| HeaderPictureCenter | Gets or sets the GrapeCity.Documents.Imaging.GcBitmap or XLPictureShape for the center part of the header. |
| HeaderPictureLeft | Gets or sets the GrapeCity.Documents.Imaging.GcBitmap or XLPictureShape for the left part of the header. |
| HeaderPictureRight | Gets or sets the GrapeCity.Documents.Imaging.GcBitmap or XLPictureShape for the right part of the header. |
| Landscape | Gets or sets whether to print the sheet in landscape mode. |
| MarginBottom | Gets or sets the bottom margin, in inches. Set to a negative value to use the default margin. |
| MarginFooter | Gets or sets the footer margin, in inches. Set to a negative value to use the default margin. |
| MarginHeader | Gets or sets the header margin, in inches. Set to a negative value to use the default margin. |
| MarginLeft | Gets or sets the left margin, in inches. Set to a negative value to use the default margin. |
| MarginRight | Gets or sets the right margin, in inches. Set to a negative value to use the default margin. |
| MarginTop | Gets or sets the top margin, in inches. Set to a negative value to use the default margin. |
| PaperKind | Gets or sets the paper size to use when printing the sheet. |
| PaperSize | Gets the paper size in points. |
| PrintGridlines | Gets or sets whether the gridlines will be printed. |
| PrintHeaders | Gets or sets whether row and column headers (the areas with row numbers and column letters) will be printed. |
| PrintPagesInRows | Gets or sets whether to print the pages in rows (across first) or in columns (down first). |
| ScaleWithDocument | Gets or sets the scales header/footer with document used for printed output. |
| ScalingFactor | Gets or sets the scaling factor (in percent) to use when printing the sheet. |
| StartPage | Gets or sets the initial page number to use when printing the sheet. |
Methods
| Name | Description |
|---|---|
| Clone() | Creates a new XLPrintSettings object that is a copy of the current instance. |