Class ExcelWorkbookView¶

Namespace: OfficeOpenXml
Assembly: EPPlus.dll

Access to workbook view properties

public class ExcelWorkbookView : XmlHelper

Inheritance¶

object ← XmlHelper ← ExcelWorkbookView

Inherited Members¶

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

Properties¶

ActiveTab¶

The active worksheet in the workbook. Zero based.

public int ActiveTab { get; set; }

Property Value¶

int

FirstSheet¶

The first visible worksheet in the worksheets collection.

public int? FirstSheet { get; set; }

Property Value¶

int?

Height¶

Height of the workbook window. In twips.

public int Height { get; }

Property Value¶

int

Left¶

Position of the upper left corner of the workbook window. In twips.

public int Left { get; }

Property Value¶

int

Minimized¶

If true the the workbook window is minimized.

public bool Minimized { get; set; }

Property Value¶

bool

ShowHorizontalScrollBar¶

Show the horizontal scrollbar

public bool ShowHorizontalScrollBar { get; set; }

Property Value¶

bool

ShowSheetTabs¶

Show or hide the sheet tabs

public bool ShowSheetTabs { get; set; }

Property Value¶

bool

ShowVerticalScrollBar¶

Show the vertical scrollbar

public bool ShowVerticalScrollBar { get; set; }

Property Value¶

bool

TabRatio¶

The ratio between the sheet tabs and the horizontal scrollbar. Default value is 600.

public int TabRatio { get; set; }

Property Value¶

int

Top¶

Position of the upper left corner of the workbook window. In twips.

public int Top { get; }

Property Value¶

int

Visibility¶

Represents the visible state of the workbook window.

public eWorkbookVisibility Visibility { get; set; }

Property Value¶

eWorkbookVisibility

Width¶

Width of the workbook window. In twips.

public int Width { get; }

Property Value¶

int

Methods¶

SetWindowSize(int, int, int, int)¶

Set the window position in twips

public void SetWindowSize(int left, int top, int width, int height)

Parameters¶

left int

Left coordinat

top int

Top coordinat

width int

Width in twips

height int

Height in twips