Interface IXLSheetView

Namespace

SlapKit.Excel.Excel

Assembly

SlapKit.Excel.dll

public interface IXLSheetView : IXLSheetViewBase

Inherited Members

IXLSheetViewBase.ZoomScale

Extension Methods

AttributeExtensions.GetMethod<T>(T, Expression<Action<T>>)

AttributeExtensions.GetMethod<T>(T, Expression<Func<T, object>>)

Properties

SplitColumn

Gets or sets the column after which the horizontal split should take place.

int SplitColumn { get; set; }

Property Value

int

SplitRow

Gets or sets the row after which the vertical split should take place.

int SplitRow { get; set; }

Property Value

int

TopLeftCellAddress

Gets or sets the location of the top left visible cell

IXLAddress TopLeftCellAddress { get; set; }

Property Value

IXLAddress

The scroll position's top left cell.

View

XLSheetViewOptions View { get; set; }

Property Value

XLSheetViewOptions

Worksheet

IXLWorksheet Worksheet { get; }

Property Value

IXLWorksheet

ZoomScaleNormal

Zoom magnification to use when in normal view. Horizontal and vertical scale together

int ZoomScaleNormal { get; set; }

Property Value

int

Remarks

Representing percent values ranging from 10 to 400.

ZoomScalePageLayoutView

Zoom magnification to use when in page layout view. Horizontal and vertical scale together.

int ZoomScalePageLayoutView { get; set; }

Property Value

int

Remarks

Representing percent values ranging from 10 to 400.

ZoomScaleSheetLayoutView

Zoom magnification to use when in page break preview. Horizontal and vertical scale together.

int ZoomScaleSheetLayoutView { get; set; }

Property Value

int

Remarks

Representing percent values ranging from 10 to 400.

Methods

Freeze(int, int)

Freezes the specified rows and columns.

void Freeze(int rows, int columns)

Parameters

rows int

The rows to freeze.

columns int

The columns to freeze.

FreezeColumns(int)

Freezes the left X columns.

void FreezeColumns(int columns)

Parameters

columns int

The columns to freeze.

FreezeRows(int)

Freezes the top X rows.

void FreezeRows(int rows)

Parameters

rows int

The rows to freeze.

SetView(XLSheetViewOptions)

IXLSheetView SetView(XLSheetViewOptions value)

Parameters

value XLSheetViewOptions

Returns

IXLSheetView