ExcelSheetView
OfficeIMO.Excel
The worksheet's view: frozen panes, gridlines, zero values, headings, direction, zoom and view mode. Values are read from and written to the worksheet's first sheet view.
Inheritance
- object
- ExcelSheetView
Usage
Explore 2 API references to this type
This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.
Returned or exposed by 2
- Property ExcelSheet.View
- Method ExcelSheetView.Freeze
Methods
public ExcelSheetView Freeze(int topRows = 0, int leftColumns = 0) #Freezes the top rows and left columns; zero for both removes frozen panes.
Parameters
- topRows int = 0
- Number of rows at the top to freeze.
- leftColumns int = 0
- Number of columns on the left to freeze.
Returns
ExcelSheetViewpublic ExcelWorksheetViewInfo Inspect() #Reads pane, split, selection and zoom details of the sheet view.
Returns
ExcelWorksheetViewInfoInherited Methods
Properties
public int FrozenRows { get; } #Number of frozen rows; zero when no panes are frozen.
public int FrozenColumns { get; } #Number of frozen columns; zero when no panes are frozen.
public bool ShowZeros { get; set; } #Whether zero values are shown; false shows such cells blank.
public bool ShowRowColumnHeadings { get; set; } #Whether row numbers and column letters are shown.
public bool RightToLeft { get; set; } #Whether the sheet is displayed from right to left.
public uint? ZoomScale { get; set; } #Zoom percentage (10-400); null when the sheet stores none.
public uint? ZoomScaleNormal { get; set; } #Zoom percentage (10-400) used by the normal view; null when the sheet stores none.
public ExcelWorksheetViewKind Kind { get; set; } #View mode: normal, page break preview or page layout.