Class ExcelWorksheetView

Represents the different view states of the worksheet

Inheritance

System.Object

XmlHelper

ExcelWorksheetView

Inherited Members

System.Object.ToString()

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

Namespace: Experior.Core.Data.OfficeOpenXml

Assembly: Experior.Core.dll

Syntax

public class ExcelWorksheetView : XmlHelper

Properties

ActiveCell

The active cell.

Declaration

public string ActiveCell { get; set; }

Property Value

Type	Description
System.String

PageBreakView

Sets the view mode of the worksheet to pagebreak

Declaration

public bool PageBreakView { get; set; }

Property Value

Type	Description
System.Boolean

PageLayoutView

Sets the view mode of the worksheet to pagelayout

Declaration

public bool PageLayoutView { get; set; }

Property Value

Type	Description
System.Boolean

Panes

Reference to the panes

Declaration

public ExcelWorksheetView.ExcelWorksheetPanes[] Panes { get; }

Property Value

Type	Description
ExcelWorksheetView.ExcelWorksheetPanes[]

RightToLeft

Flag indicating whether the sheet is in 'right to left' display mode. When in this mode,Column A is on the far right, Column B ;is one column left of Column A, and so on. Also,information in cells is displayed in the Right to Left format.

Declaration

public bool RightToLeft { get; set; }

Property Value

Type	Description
System.Boolean

SelectedRange

Selected Cells in the worksheet.Used in combination with ActiveCell

Declaration

public string SelectedRange { get; set; }

Property Value

Type	Description
System.String

SheetViewElement

Returns a reference to the sheetView element

Declaration

protected XmlElement SheetViewElement { get; }

Property Value

Type	Description
System.Xml.XmlElement

ShowGridLines

Show gridlines in the worksheet

Declaration

public bool ShowGridLines { get; set; }

Property Value

Type	Description
System.Boolean

ShowHeaders

Show the Column/Row headers (containg column letters and row numbers)

Declaration

public bool ShowHeaders { get; set; }

Property Value

Type	Description
System.Boolean

TabSelected

Indicates if the worksheet is selected within the workbook

Declaration

public bool TabSelected { get; set; }

Property Value

Type	Description
System.Boolean

ZoomScale

Window zoom magnification for current view representing percent values.

Declaration

public int ZoomScale { get; set; }

Property Value

Type	Description
System.Int32

Methods

FreezePanes(Int32, Int32)

Freeze the columns/rows to left and above the cell

Declaration

public void FreezePanes(int Row, int Column)

Parameters

Type	Name	Description
System.Int32	Row
System.Int32	Column

UnFreezePanes()

Unlock all rows and columns to scroll freely ///

Declaration

public void UnFreezePanes()