Class ExcelPrinterSettings

Printer settings

Inheritance

object

XmlHelper

ExcelPrinterSettings

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.ReferenceEquals(object, object)

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
bool

BottomMargin

Bottom margin in inches

Declaration

public double BottomMargin { get; set; }

Property Value

Type	Description
double

Draft

Print a draft

Declaration

public bool Draft { get; set; }

Property Value

Type	Description
bool

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
int

FitToPage

Fit To Page.

Declaration

public bool FitToPage { get; set; }

Property Value

Type	Description
bool

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
int

FooterMargin

Footer margin in inches

Declaration

public double FooterMargin { get; set; }

Property Value

Type	Description
double

HeaderMargin

Header margin in inches

Declaration

public double HeaderMargin { get; set; }

Property Value

Type	Description
double

HorizontalCentered

Horizontal centered when printing

Declaration

public bool HorizontalCentered { get; set; }

Property Value

Type	Description
bool

LeftMargin

Left margin in inches

Declaration

public double LeftMargin { get; set; }

Property Value

Type	Description
double

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 double RightMargin { get; set; }

Property Value

Type	Description
double

Scale

Print scale

Declaration

public int Scale { get; set; }

Property Value

Type	Description
int

ShowGridLines

Print gridlines

Declaration

public bool ShowGridLines { get; set; }

Property Value

Type	Description
bool

ShowHeaders

Print headings (column letter and row numbers)

Declaration

public bool ShowHeaders { get; set; }

Property Value

Type	Description
bool

TopMargin

Top margin in inches

Declaration

public double TopMargin { get; set; }

Property Value

Type	Description
double

VerticalCentered

Vertical centered when printing

Declaration

public bool VerticalCentered { get; set; }

Property Value

Type	Description
bool