ExcelWorksheetView Members

Office Open XML

The ExcelWorksheetView type exposes the following members.

Methods

  NameDescription
Equals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
FreezePanes
Freeze the columns/rows to left and above the cell
GetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
GetType
Gets the Type of the current instance.
(Inherited from Object.)
ToString
Returns a String that represents the current Object.
(Inherited from Object.)
UnFreezePanes
Unlock all rows and columns to scroll freely ///

Properties

  NameDescription
ActiveCell
The active cell.
PageBreakView
Sets the view mode of the worksheet to pagebreak
PageLayoutView
Sets the view mode of the worksheet to pagelayout
Panes
Reference to the panes
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.
SelectedRange
Selected Cells in the worksheet.Used in combination with ActiveCell
ShowGridLines
Show gridlines in the worksheet
ShowHeaders
Show the Column/Row headers (containg column letters and row numbers)
TabSelected
Indicates if the worksheet is selected within the workbook
ZoomScale
Window zoom magnification for current view representing percent values.

See Also