Class ExcelPrinterSettings

Namespace

OfficeOpenXml

Assembly

EPPlus.dll

Printer settings

public sealed class ExcelPrinterSettings : XmlHelper

Inheritance

object

XmlHelper

ExcelPrinterSettings

Inherited Members

object.GetType()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

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