Interface
IWorksheetViewExporter

Streams worksheet viewport and selection state (scroll position, panes, zoom, grid/headers visibility, selection).

Definition

Namespace:Telerik.Documents.SpreadsheetStreaming

Assembly:Telerik.Documents.SpreadsheetStreaming.dll

Syntax:

cs-api-definition

public interface IWorksheetViewExporter : IDisposable

Inherited Members IDisposable.Dispose()

Methods

AddSelectionRange(int, int, int, int)

Add a rectangular range to the multi-range selection.

Declaration

cs-api-definition

void AddSelectionRange(int fromRowIndex, int fromColumnIndex, int toRowIndex, int toColumnIndex)

Parameters

fromRowIndex

int

The row index of the top left cell of the range.

fromColumnIndex

int

The column index of the top left cell of the range.

toRowIndex

int

The row index of the bottom right cell of the range.

toColumnIndex

int

The column index of the bottom right cell of the range.

SetActiveSelectionCell(int, int)

Set the active (anchor) cell of the current selection.

Declaration

cs-api-definition

void SetActiveSelectionCell(int rowIndex, int columnIndex)

Parameters

rowIndex

int

The row index of the active cell.

columnIndex

int

The column index of the active cell.

SetFirstVisibleCell(int, int)

Set the first visible cell (scroll origin) of the worksheet view.

Declaration

cs-api-definition

void SetFirstVisibleCell(int rowIndex, int columnIndex)

Parameters

rowIndex

int

The row index.

columnIndex

int

The column index.

SetFreezePanes(int, int)

Freeze the specified number of top rows and left columns to keep them visible while scrolling.

Declaration

cs-api-definition

void SetFreezePanes(int rowsCount, int columnsCount)

Parameters

rowsCount

int

The number of frozen rows.

columnsCount

int

The number of frozen column.

SetFreezePanes(int, int, int, int)

Freeze panes and specify the first visible cell within the scrollable (bottom-right) pane.

Declaration

cs-api-definition

void SetFreezePanes(int rowsCount, int columnsCount, int scrollablePaneFirstVisibleCellRowIndex, int scrollablePaneFirstVisibleCellColumnIndex)

Parameters

rowsCount

int

The number of frozen rows.

columnsCount

int

The number of frozen column.

scrollablePaneFirstVisibleCellRowIndex

int

The scrollable pane first visible cell row index.

scrollablePaneFirstVisibleCellColumnIndex

int

The scrollable pane first visible cell column index.

SetScaleFactor(double)

Set the zoom percentage (scale factor) applied to the sheet view.

Declaration

cs-api-definition

void SetScaleFactor(double percent)

Parameters

percent

double

The percentage that the viewport will be scaled to.

SetShouldShowGridLines(bool)

Show or hide gridlines in the worksheet viewport.

Declaration

cs-api-definition

void SetShouldShowGridLines(bool value)

Parameters

value

bool

True for visible gridlines, otherwise False.

SetShouldShowRowColumnHeaders(bool)

Show or hide the row and column headers.

Declaration

cs-api-definition

void SetShouldShowRowColumnHeaders(bool value)

Parameters

value

bool

True for visible row and column headers, otherwise False.

InterfaceIWorksheetViewExporter

Interface
IWorksheetViewExporter