initialization and opening of a spreadsheet file values for packed: :zip
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
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 all values in this row as an array row numbers are 1,2,3,… like in the spreadsheet
returns an array of sheet names in the spreadsheet
shows the internal representation of all cells for debugging purposes
[Validate]