Class ExcelWorkbookView
Access to workbook view properties
Inherited Members
Namespace: OfficeOpenXml
Assembly: EPPlus.dll
Syntax
public class ExcelWorkbookView : XmlHelperProperties
ActiveTab
The active worksheet in the workbook. Zero based.
Declaration
public int ActiveTab { get; set; }Property Value
| Type | Description |
|---|---|
| int |
FirstSheet
The first visible worksheet in the worksheets collection.
Declaration
public int? FirstSheet { get; set; }Property Value
| Type | Description |
|---|---|
| int? |
Height
Height of the workbook window. In twips.
Declaration
public int Height { get; }Property Value
| Type | Description |
|---|---|
| int |
Left
Position of the upper left corner of the workbook window. In twips.
Declaration
public int Left { get; }Property Value
| Type | Description |
|---|---|
| int |
Minimized
If true the the workbook window is minimized.
Declaration
public bool Minimized { get; set; }Property Value
| Type | Description |
|---|---|
| bool |
ShowHorizontalScrollBar
Show the horizontal scrollbar
Declaration
public bool ShowHorizontalScrollBar { get; set; }Property Value
| Type | Description |
|---|---|
| bool |
ShowSheetTabs
Show or hide the sheet tabs
Declaration
public bool ShowSheetTabs { get; set; }Property Value
| Type | Description |
|---|---|
| bool |
ShowVerticalScrollBar
Show the vertical scrollbar
Declaration
public bool ShowVerticalScrollBar { get; set; }Property Value
| Type | Description |
|---|---|
| bool |
TabRatio
The ratio between the sheet tabs and the horizontal scrollbar. Default value is 600.
Declaration
public int TabRatio { get; set; }Property Value
| Type | Description |
|---|---|
| int |
Top
Position of the upper left corner of the workbook window. In twips.
Declaration
public int Top { get; }Property Value
| Type | Description |
|---|---|
| int |
Visibility
Represents the visible state of the workbook window.
Declaration
public eWorkbookVisibility Visibility { get; set; }Property Value
| Type | Description |
|---|---|
| eWorkbookVisibility |
Width
Width of the workbook window. In twips.
Declaration
public int Width { get; }Property Value
| Type | Description |
|---|---|
| int |
Methods
SetWindowSize(int, int, int, int)
Set the window position in twips
Declaration
public void SetWindowSize(int left, int top, int width, int height)Parameters
| Type | Name | Description |
|---|---|---|
| int | left | Left coordinat |
| int | top | Top coordinat |
| int | width | Width in twips |
| int | height | Height in twips |