Interface IWorksheetViewExporter
Streams worksheet viewport and selection state (scroll position, panes, zoom, grid/headers visibility, selection).
Inherited Members
Namespace: Telerik.Documents.SpreadsheetStreaming
Assembly: Telerik.Documents.SpreadsheetStreaming.dll
Syntax
public interface IWorksheetViewExporter : IDisposableMethods
AddSelectionRange(Int32, Int32, Int32, Int32)
Add a rectangular range to the multi-range selection.
Declaration
void AddSelectionRange(int fromRowIndex, int fromColumnIndex, int toRowIndex, int toColumnIndex)Parameters
|
System.Int32
fromRowIndex
The row index of the top left cell of the range. |
|
System.Int32
fromColumnIndex
The column index of the top left cell of the range. |
|
System.Int32
toRowIndex
The row index of the bottom right cell of the range. |
|
System.Int32
toColumnIndex
The column index of the bottom right cell of the range. |
SetActiveSelectionCell(Int32, Int32)
Set the active (anchor) cell of the current selection.
Declaration
void SetActiveSelectionCell(int rowIndex, int columnIndex)Parameters
|
System.Int32
rowIndex
The row index of the active cell. |
|
System.Int32
columnIndex
The column index of the active cell. |
SetFirstVisibleCell(Int32, Int32)
Set the first visible cell (scroll origin) of the worksheet view.
Declaration
void SetFirstVisibleCell(int rowIndex, int columnIndex)Parameters
|
System.Int32
rowIndex
The row index. |
|
System.Int32
columnIndex
The column index. |
SetFreezePanes(Int32, Int32)
Freeze the specified number of top rows and left columns to keep them visible while scrolling.
Declaration
void SetFreezePanes(int rowsCount, int columnsCount)Parameters
|
System.Int32
rowsCount
The number of frozen rows. |
|
System.Int32
columnsCount
The number of frozen column. |
SetFreezePanes(Int32, Int32, Int32, Int32)
Freeze panes and specify the first visible cell within the scrollable (bottom-right) pane.
Declaration
void SetFreezePanes(int rowsCount, int columnsCount, int scrollablePaneFirstVisibleCellRowIndex, int scrollablePaneFirstVisibleCellColumnIndex)Parameters
|
System.Int32
rowsCount
The number of frozen rows. |
|
System.Int32
columnsCount
The number of frozen column. |
|
System.Int32
scrollablePaneFirstVisibleCellRowIndex
The scrollable pane first visible cell row index. |
|
System.Int32
scrollablePaneFirstVisibleCellColumnIndex
The scrollable pane first visible cell column index. |
SetScaleFactor(Double)
Set the zoom percentage (scale factor) applied to the sheet view.
Declaration
void SetScaleFactor(double percent)Parameters
|
System.Double
percent
The percentage that the viewport will be scaled to. |
SetShouldShowGridLines(Boolean)
Show or hide gridlines in the worksheet viewport.
Declaration
void SetShouldShowGridLines(bool value)Parameters
|
System.Boolean
value
True for visible gridlines, otherwise False. |
SetShouldShowRowColumnHeaders(Boolean)
Show or hide the row and column headers.
Declaration
void SetShouldShowRowColumnHeaders(bool value)Parameters
|
System.Boolean
value
True for visible row and column headers, otherwise False. |