Returns the content of a spreadsheet-cell. (1,1) is the upper left corner. (1,1), (1,’A’), (‘A’,1), (‘a’,1) all refers to the cell at the first line and first row.
returns the type of a cell:
returns all values in this column as an array column numbers are 1,2,3,… like in the spreadsheet
true, if the cell is empty
returns the first non-empty column in a sheet
returns the first non-empty row in a sheet
Returns the formula at (row,col). Returns nil if there is no formula. The method formula? checks if there is a formula.
true, if there is a formula
returns each formula in the selected sheet as an array of elements [row, col, formula]
returns the last non-empty column in a sheet
returns the last non-empty row in a sheet
returns all values in this row as an array row numbers are 1,2,3,… like in the spreadsheet
sets the cell to the content of ‘value’ a formula can be set in the form of ’=SUM(…)’
returns an array of sheet names in the spreadsheet