Class ExcelPrinterSettings¶

Namespace: OfficeOpenXml
Assembly: EPPlus.dll

Printer settings

public sealed class ExcelPrinterSettings : XmlHelper

Inheritance¶

object ← XmlHelper ← ExcelPrinterSettings

Inherited Members¶

object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.ReferenceEquals(object?, object?)
object.ToString()

Properties¶

BlackAndWhite¶

Print black and white

public bool BlackAndWhite { get; set; }

Property Value¶

bool

BottomMargin¶

Bottom margin in inches

public decimal BottomMargin { get; set; }

Property Value¶

decimal

Draft¶

Print a draft

public bool Draft { get; set; }

Property Value¶

bool

FitToHeight¶

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

public int FitToHeight { get; set; }

Property Value¶

int

FitToPage¶

Fit To Page.

public bool FitToPage { get; set; }

Property Value¶

bool

FitToWidth¶

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

public int FitToWidth { get; set; }

Property Value¶

int

FooterMargin¶

Footer margin in inches

public decimal FooterMargin { get; set; }

Property Value¶

decimal

HeaderMargin¶

Header margin in inches

public decimal HeaderMargin { get; set; }

Property Value¶

decimal

HorizontalCentered¶

Horizontal centered when printing

public bool HorizontalCentered { get; set; }

Property Value¶

bool

LeftMargin¶

Left margin in inches

public decimal LeftMargin { get; set; }

Property Value¶

decimal

Orientation¶

Orientation Portrait or Landscape

public eOrientation Orientation { get; set; }

Property Value¶

eOrientation

PageOrder¶

Specifies printed page order

public ePageOrder PageOrder { get; set; }

Property Value¶

ePageOrder

PaperSize¶

Paper size

public ePaperSize PaperSize { get; set; }

Property Value¶

ePaperSize

PrintArea¶

The printarea. Null if no print area is set.

public ExcelRangeBase PrintArea { get; set; }

Property Value¶

ExcelRangeBase

RepeatColumns¶

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

public ExcelAddress RepeatColumns { get; set; }

Property Value¶

ExcelAddress

RepeatRows¶

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

public ExcelAddress RepeatRows { get; set; }

Property Value¶

ExcelAddress

RightMargin¶

Right margin in inches

public decimal RightMargin { get; set; }

Property Value¶

decimal

Scale¶

Print scale

public int Scale { get; set; }

Property Value¶

int

ShowGridLines¶

Print gridlines

public bool ShowGridLines { get; set; }

Property Value¶

bool

ShowHeaders¶

Print headings (column letter and row numbers)

public bool ShowHeaders { get; set; }

Property Value¶

bool

TopMargin¶

Top margin in inches

public decimal TopMargin { get; set; }

Property Value¶

decimal

VerticalCentered¶

Vertical centered when printing

public bool VerticalCentered { get; set; }

Property Value¶

bool