SpreadsheetSheetBuilder
Defines the fluent API for configuring the SpreadsheetSheet settings.
Methods
ActiveCell(System.String)
The active cell in the sheet, for example, A1.
Parameters
value - System.String
The value that configures the activecell.
Name(System.String)
The name of the sheet.
Parameters
value - System.String
The value that configures the name.
Columns(System.Action)
An array which defines the columns in this sheet and their content.
Parameters
configurator - System.Action<SpreadsheetSheetColumnFactory>
The action that configures the columns.
Drawings(System.Action)
An array which contains the drawings used in this sheet.
Parameters
configurator - System.Action<SpreadsheetSheetDrawingFactory>
The action that configures the drawings.
Filter(System.Action)
Defines the filtering criteria for this sheet, if any.
Parameters
configurator - System.Action<SpreadsheetSheetFilterSettingsBuilder>
The action that configures the filter.
FrozenColumns(System.Int32)
The number of frozen columns in this sheet.
Parameters
value - System.Int32
The value that configures the frozencolumns.
FrozenRows(System.Int32)
The number of frozen rows in this sheet.
Parameters
value - System.Int32
The value that configures the frozenrows.
MergedCells(System.String[])
An array of merged cell ranges, for example, B1:D2.
Parameters
value - System.String[]
The value that configures the mergedcells.
Rows(System.Action)
The row data for this sheet.
Parameters
configurator - System.Action<SpreadsheetSheetRowFactory>
The action that configures the rows.
Selection(System.String)
The selected range in the sheet, for example, A1:B10.
Parameters
value - System.String
The value that configures the selection.
ShowGridLines(System.Boolean)
A Boolean value which indicates if the grid lines of the sheet will be displayed.
Parameters
value - System.Boolean
The value that configures the showgridlines.
Sort(System.Action)
Defines the sort criteria for the sheet.
Parameters
configurator - System.Action<SpreadsheetSheetSortSettingsBuilder>
The action that configures the sort.
DataSource(System.Action)
Sets the data source configuration of the grid.
Parameters
configurator - System.Action<DataSourceBuilder>
The lambda which configures the data source