Represents a table that can be added in a sheet.
Syntax
var instance = new GcSpread.Sheets.SheetTable(name, row, col, rowCount, colCount, style);
function SheetTable;
Inheritance Hierarchy
Object
GcSpread.Sheets.SheetTable
Constructors
| Name | Description | |
|---|---|---|
 | SheetTable Constructor | Represents a table that can be added in a sheet. |
Methods
| Name | Description | |
|---|---|---|
 | autoGenerateColumns | Gets or sets whether to generate columns automatically while binding to a data source. |
| bandColumns | Gets or sets a value that indicates whether to display an alternating column style. |
| bandRows | Gets or sets a value that indicates whether to display an alternating row style. |
| bindColumns | Binds the columns using the specified data fields. |
| bindingPath | Gets or sets the binding path for cell-level binding in the table. |
| dataRange | Gets the cell range for the table data area. |
| filterButtonVisible | Gets or sets whether the table column's filter button is displayed. |
| footerIndex | Gets the footer index in the sheet. |
| getColumnFormula | Gets the table footer formula with the specified index. |
| getColumnName | Gets the table header text with the specified table index. |
| getColumnValue | Gets the table footer value with the specified index. |
| getSlicerData | Gets the slicer data of the table. |
| headerIndex | Gets the header index in the sheet. |
| highlightFirstColumn | Gets or sets a value that indicates whether to highlight the first column. |
| highlightLastColumn | Gets or sets a value that indicates whether to highlight the last column. |
| name | Gets or sets the table name. |
| range | Gets the range for the whole table. |
| refresh | Reloads the data from a data source. |
| rowFilter | Gets the row filter for the table. |
| setColumnDataFormula | Sets a formula to the table's data range with the specified index. |
| setColumnFormula | Sets the table footer formula with the specified index. |
| setColumnName | Sets the table header text with the specified table index. |
| setColumnValue | Sets the table footer value with the specified index. |
| showFooter | Gets or sets a value that indicates whether to display a footer. |
| showHeader | Gets or sets a value that indicates whether to display a header. |
| style | Gets or sets a style for the table. |
See Also