FsWorksheet Type
Creates an FsWorksheet with the given name, FsRows, FsTables, and FsCellsCollection.
Constructors
Constructor | Description |
Full Usage:
FsWorksheet(name, ?fsRows, ?fsTables, ?fsCellsCollection)
Parameters:
string
?fsRows : ResizeArray<FsRow>
?fsTables : ResizeArray<FsTable>
?fsCellsCollection : FsCellsCollection
Returns: FsWorksheet
|
|
Instance members
Instance member | Description | ||||
|
|||||
|
|||||
|
|||||
|
|||||
|
|
||||
|
|||||
|
|
||||
|
|
||||
Full Usage:
this.ContainsRowAt
Parameters:
int
Returns: bool
|
|||||
|
|
||||
|
|||||
|
|
||||
Full Usage:
this.GetRowValuesAt
Parameters:
int
Returns: obj seq
|
|||||
|
|
||||
Full Usage:
this.InsertValueAt
Parameters:
obj
rowIndex : int
colIndex : int
|
|||||
|
|
||||
|
|
||||
Full Usage:
this.MaxColumnIndex
Returns: int32
|
|
||||
Full Usage:
this.MaxRowIndex
Returns: int32
|
|
||||
Full Usage:
this.Name
|
|||||
|
|||||
Full Usage:
this.RemoveRowAt
Parameters:
int
|
|||||
Full Usage:
this.RemoveValueAt
Parameters:
int
colIndex : int
|
|
||||
Full Usage:
this.RescanRows
|
|||||
Full Usage:
this.RowWithRange
Parameters:
FsRangeAddress
-
The range address of the FsRow.
?SkipSearch : bool
-
If true, the FsRow is created and appended without checking if it already exists.
Returns: FsRow
|
|
||||
|
|||||
Full Usage:
this.SetValueAt
Parameters:
'a
rowIndex : int32
colIndex : int32
Returns: FsWorksheet
|
|||||
Full Usage:
this.SortRows
|
|||||
Full Usage:
this.Table
Parameters:
string
rangeAddress : FsRangeAddress
?showHeaderRow : bool
Returns: FsTable
|
|||||
|
|
||||
|
|||||
Full Usage:
this.TryGetRowValuesAt
Parameters:
int
Returns: obj seq option
|
|||||
|
|||||
Full Usage:
this.TryRemoveValueAt
Parameters:
int
colIndex : int
|
Does nothing if the row or column of given index does not exist.
|
Static members
Static member | Description | ||||
Full Usage:
FsWorksheet.addCell cell sheet
Parameters:
FsCell
sheet : FsWorksheet
Returns: FsWorksheet
|
|||||
Full Usage:
FsWorksheet.addCells cell sheet
Parameters:
FsCell seq
sheet : FsWorksheet
Returns: FsWorksheet
|
|||||
Full Usage:
FsWorksheet.addTable table sheet
Parameters:
FsTable
sheet : FsWorksheet
Returns: FsWorksheet
|
|||||
Full Usage:
FsWorksheet.addTables tables sheet
Parameters:
'a list
sheet : FsWorksheet
Returns: FsWorksheet
|
|||||
Full Usage:
FsWorksheet.appendRow row sheet
Parameters:
FsRow
sheet : FsWorksheet
Returns: FsWorksheet
|
|||||
Full Usage:
FsWorksheet.containsRowAt rowIndex sheet
Parameters:
int
sheet : FsWorksheet
Returns: bool
|
|||||
|
|||||
|
|||||
Full Usage:
FsWorksheet.getCellAt rowIndex colIndex sheet
Parameters:
int32
colIndex : int32
sheet : FsWorksheet
Returns: FsCell
|
|||||
Full Usage:
FsWorksheet.getColumnAt columnIndex sheet
Parameters:
int
sheet : FsWorksheet
Returns: FsColumn
|
|||||
|
|||||
|
|||||
Full Usage:
FsWorksheet.getRowAt rowIndex sheet
Parameters:
int
sheet : FsWorksheet
Returns: FsRow
|
|||||
Full Usage:
FsWorksheet.getRowValuesAt rowIndex sheet
Parameters:
int
sheet : FsWorksheet
Returns: obj seq
|
|||||
|
|||||
Full Usage:
FsWorksheet.getTableByName tableName sheet
Parameters:
string
sheet : FsWorksheet
Returns: FsTable
|
|||||
|
|||||
Full Usage:
FsWorksheet.insertBefore row refRow sheet
Parameters:
FsRow
refRow : FsRow
sheet : FsWorksheet
Returns: FsWorksheet
|
|||||
Full Usage:
FsWorksheet.insertValueAt value rowIndex colIndex sheet
Parameters:
'a
rowIndex : int
colIndex : int
sheet : FsWorksheet
|
|
||||
Full Usage:
FsWorksheet.mapRowsInPlace f sheet
Parameters:
FsRow -> FsRow
sheet : FsWorksheet
Returns: FsWorksheet
|
|||||
Full Usage:
FsWorksheet.removeCellAt rowIndex colIndex sheet
Parameters:
int
colIndex : int
sheet : FsWorksheet
Returns: FsWorksheet
|
|||||
Full Usage:
FsWorksheet.removeRowAt rowIndex sheet
Parameters:
int
sheet : FsWorksheet
Returns: FsWorksheet
|
|||||
Full Usage:
FsWorksheet.removeValueAt rowIndex colIndex sheet
Parameters:
int
colIndex : int
sheet : FsWorksheet
|
|
||||
Full Usage:
FsWorksheet.setValueAt value rowIndex colIndex sheet
Parameters:
'a
rowIndex : int32
colIndex : int32
sheet : FsWorksheet
Returns: FsWorksheet
|
|||||
Full Usage:
FsWorksheet.tryGetCellAt rowIndex colIndex sheet
Parameters:
int32
colIndex : int32
sheet : FsWorksheet
Returns: FsCell option
|
|||||
Full Usage:
FsWorksheet.tryGetColumnAt columnIndex sheet
Parameters:
int
sheet : FsWorksheet
Returns: FsColumn option
|
|||||
Full Usage:
FsWorksheet.tryGetRowAfter rowIndex sheet
Parameters:
int
sheet : FsWorksheet
Returns: FsRow option
|
|||||
Full Usage:
FsWorksheet.tryGetRowAt rowIndex sheet
Parameters:
int
sheet : FsWorksheet
Returns: FsRow option
|
|||||
Full Usage:
FsWorksheet.tryGetRowValuesAt rowIndex sheet
Parameters:
int
sheet : FsWorksheet
Returns: obj seq option
|
|||||
Full Usage:
FsWorksheet.tryGetTableByName tableName sheet
Parameters:
string
sheet : FsWorksheet
Returns: FsTable option
|
|||||
|
|
||||
Full Usage:
FsWorksheet.tryRemoveValueAt rowIndex colIndex sheet
Parameters:
int
colIndex : int
sheet : FsWorksheet
|
Does nothing if the row or column of given index does not exist.
|