SpreadSheetFlexsheet¶
Definition¶
Extends¶
Extended By¶
None
Description¶
Builder for generating a Spreadsheet Worksheet
Method Summary¶
| Owner | Name | Return Type | Description |
|---|---|---|---|
| SpreadSheetFlexsheet | constructor() | SpreadSheetFlexsheet | Creates a builder for generating a Spreadsheet |
| Object | getClassName() | String | Returns the string name of this object's class type. |
| SpreadSheetFlexsheet | getStyle(dimension) | Integer | Gets the style id for a specified range cell, returns null if it does not exist |
| SpreadSheetFlexsheet | getTitle() | String | Gets the name of the underlying sheet |
| SpreadSheetFlexsheet | getValue(dimension) | Object | Gets the value of a single cell. Note that this is the underlying excel value not what excel might compute |
| SpreadSheetFlexsheet | setStyle(dimensions, id) | Boolean | Sets the style id for the specified range of cells |
| SpreadSheetFlexsheet | setTitle(title) | String | Sets the name of the underlying sheet |
| SpreadSheetFlexsheet | setValue(dimensions, value) | Boolean | Sets the value for the specified range of cells |
| SpreadSheetFlexsheet | setValue(dimension, value, useHeader) | Boolean | Sets the value for the specified range of cells using a table. Expects the top left position of the table as the input dimension |
| Object | toJson() | String | Returns a json representation of this object. |
Method Definitions¶
constructor()¶
SpreadSheetFlexsheet spreadsheetflexsheet = new SpreadSheetFlexsheet()
Description¶
Creates a builder for generating a Spreadsheet
getStyle(dimension)¶
Integer SpreadSheetFlexsheet::getStyle(String dimension)
Description¶
Gets the style id for a specified range cell, returns null if it does not exist
Parameter Definition¶
| Name | Type | Description |
|---|---|---|
| dimension | String |
getTitle()¶
String SpreadSheetFlexsheet::getTitle()
Description¶
Gets the name of the underlying sheet
getValue(dimension)¶
Object SpreadSheetFlexsheet::getValue(String dimension)
Description¶
Gets the value of a single cell. Note that this is the underlying excel value not what excel might compute
Parameter Definition¶
| Name | Type | Description |
|---|---|---|
| dimension | String |
setStyle(dimensions,id)¶
Boolean SpreadSheetFlexsheet::setStyle(String dimensions, Integer id)
Description¶
Sets the style id for the specified range of cells
Parameter Definition¶
| Name | Type | Description |
|---|---|---|
| dimensions | String | |
| id | Integer |
setTitle(title)¶
String SpreadSheetFlexsheet::setTitle(String title)
Description¶
Sets the name of the underlying sheet
Parameter Definition¶
| Name | Type | Description |
|---|---|---|
| title | String |
setValue(dimensions,value)¶
Boolean SpreadSheetFlexsheet::setValue(String dimensions, Object value)
Description¶
Sets the value for the specified range of cells
Parameter Definition¶
| Name | Type | Description |
|---|---|---|
| dimensions | String | |
| value | Object |
setValue(dimension,value,useHeader)¶
Boolean SpreadSheetFlexsheet::setValue(String dimension, Table value, Boolean useHeader)
Description¶
Sets the value for the specified range of cells using a table. Expects the top left position of the table as the input dimension
Parameter Definition¶
| Name | Type | Description |
|---|---|---|
| dimension | String | |
| value | Table | |
| useHeader | Boolean |