Class ExcelPrinterSettings

Printer settings

Inheritance
System.Object
XmlHelper
ExcelPrinterSettings
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: OfficeOpenXml
Assembly: EPPlus.dll
Syntax
public sealed class ExcelPrinterSettings : XmlHelper

Properties

BlackAndWhite

Print black and white

Declaration
public bool BlackAndWhite { get; set; }
Property Value
Type Description
System.Boolean

BottomMargin

Bottom margin in inches

Declaration
public decimal BottomMargin { get; set; }
Property Value
Type Description
System.Decimal

Draft

Print a draft

Declaration
public bool Draft { get; set; }
Property Value
Type Description
System.Boolean

FitToHeight

Fit to height in pages. Set FitToPage to true when using this one. 0 is automatic

Declaration
public int FitToHeight { get; set; }
Property Value
Type Description
System.Int32

FitToPage

Fit To Page.

Declaration
public bool FitToPage { get; set; }
Property Value
Type Description
System.Boolean

FitToWidth

Fit to Width in pages. Set FitToPage to true when using this one. 0 is automatic

Declaration
public int FitToWidth { get; set; }
Property Value
Type Description
System.Int32

FooterMargin

Footer margin in inches

Declaration
public decimal FooterMargin { get; set; }
Property Value
Type Description
System.Decimal

HeaderMargin

Header margin in inches

Declaration
public decimal HeaderMargin { get; set; }
Property Value
Type Description
System.Decimal

HorizontalCentered

Horizontal centered when printing

Declaration
public bool HorizontalCentered { get; set; }
Property Value
Type Description
System.Boolean

LeftMargin

Left margin in inches

Declaration
public decimal LeftMargin { get; set; }
Property Value
Type Description
System.Decimal

Orientation

Orientation Portrait or Landscape

Declaration
public eOrientation Orientation { get; set; }
Property Value
Type Description
eOrientation

PageOrder

Specifies printed page order

Declaration
public ePageOrder PageOrder { get; set; }
Property Value
Type Description
ePageOrder

PaperSize

Paper size

Declaration
public ePaperSize PaperSize { get; set; }
Property Value
Type Description
ePaperSize

PrintArea

The printarea. Null if no print area is set.

Declaration
public ExcelRangeBase PrintArea { get; set; }
Property Value
Type Description
ExcelRangeBase

RepeatColumns

Print titles Columns to be repeated after each pagebreak. The address must be a full column address (ex. A:A)

Declaration
public ExcelAddress RepeatColumns { get; set; }
Property Value
Type Description
ExcelAddress

RepeatRows

Print titles Rows to be repeated after each pagebreak. The address must be a full row address (ex. 1:1)

Declaration
public ExcelAddress RepeatRows { get; set; }
Property Value
Type Description
ExcelAddress

RightMargin

Right margin in inches

Declaration
public decimal RightMargin { get; set; }
Property Value
Type Description
System.Decimal

Scale

Print scale

Declaration
public int Scale { get; set; }
Property Value
Type Description
System.Int32

ShowGridLines

Print gridlines

Declaration
public bool ShowGridLines { get; set; }
Property Value
Type Description
System.Boolean

ShowHeaders

Print headings (column letter and row numbers)

Declaration
public bool ShowHeaders { get; set; }
Property Value
Type Description
System.Boolean

TopMargin

Top margin in inches

Declaration
public decimal TopMargin { get; set; }
Property Value
Type Description
System.Decimal

VerticalCentered

Vertical centered when printing

Declaration
public bool VerticalCentered { get; set; }
Property Value
Type Description
System.Boolean