New to Telerik UI for WinForms? Start a free 30-day trial

IWorksheetViewExporter

Interface

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:

public interface IWorksheetViewExporter : IDisposable

Inherited Members IDisposable.Dispose()

Methods

AddSelectionRange(int, int, int, int)

Add a rectangular range to the multi-range selection.

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

Parameters:fromRowIndexint

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

fromColumnIndexint

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

toRowIndexint

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

toColumnIndexint

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

SetActiveSelectionCell(int, int)

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

void SetActiveSelectionCell(int rowIndex, int columnIndex)

Parameters:rowIndexint

The row index of the active cell.

columnIndexint

The column index of the active cell.

SetFirstVisibleCell(int, int)

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

void SetFirstVisibleCell(int rowIndex, int columnIndex)

Parameters:rowIndexint

The row index.

columnIndexint

The column index.

SetFreezePanes(int, int, int, int)

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

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

Parameters:rowsCountint

The number of frozen rows.

columnsCountint

The number of frozen column.

scrollablePaneFirstVisibleCellRowIndexint

The scrollable pane first visible cell row index.

scrollablePaneFirstVisibleCellColumnIndexint

The scrollable pane first visible cell column index.

SetFreezePanes(int, int)

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

void SetFreezePanes(int rowsCount, int columnsCount)

Parameters:rowsCountint

The number of frozen rows.

columnsCountint

The number of frozen column.

SetScaleFactor(double)

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

void SetScaleFactor(double percent)

Parameters:percentdouble

The percentage that the viewport will be scaled to.

SetShouldShowGridLines(bool)

Show or hide gridlines in the worksheet viewport.

void SetShouldShowGridLines(bool value)

Parameters:valuebool

True for visible gridlines, otherwise False.

SetShouldShowRowColumnHeaders(bool)

Show or hide the row and column headers.

void SetShouldShowRowColumnHeaders(bool value)

Parameters:valuebool

True for visible row and column headers, otherwise False.