Reference > Classes

SpreadSheetWorksheet¶

Definition¶

1	`SpreadSheetWorksheet var = .... ;`

Extends¶

Object

Extended By¶

None

Description¶

Builder for generating a Spreadsheet Worksheet

Method Summary¶

Owner	Name	Return Type	Description
SpreadSheetWorksheet	constructor()	SpreadSheetWorksheet	Creates a builder for generating a Spreadsheet
SpreadSheetWorksheet	addColWithFormula(position, colName, formula)	Boolean	Creates a new formula based column - use `exact column name` to automatically replace with row values (For example: addColWithFormula(2,"col3","`col1` * `col2`"); col3 -> A#*B#)
Object	getClassName()	String	Returns the string name of this object's class type.
SpreadSheetWorksheet	getTable()	Table	Gets the underlying table object
SpreadSheetWorksheet	getTitle()	String	Gets the name of the underlying sheet
SpreadSheetWorksheet	setTitle(title)	String	Sets the name of the underlying sheet
Object	toJson()	String	Returns a json representation of this object.

Method Definitions¶

constructor()¶

SpreadSheetWorksheet spreadsheetworksheet = new SpreadSheetWorksheet()

Description¶

Creates a builder for generating a Spreadsheet

addColWithFormula(position,colName,formula)¶

Boolean SpreadSheetWorksheet::addColWithFormula(Integer position, String colName, String formula)

Description¶

Creates a new formula based column - use exact column name to automatically replace with row values (For example: addColWithFormula(2,"col3","col1 * col2"); col3 -> A#*B#)