tables
table (word) | [row column (sheet)]
value
Returns the value stored in the specified table at the specified row, column, and sheet (if provided). See putcell
show cell "table [3 4]
20
tables
table (word) | column (number)
list
Returns the contents of the specified column in the specified table as a list. See row
show column "table 5
tables
table (word)
none
Erases the named table.
erase "mytable
tables
tablename (word) | filename (word)
none
Loads the specified filename from disk into the specified table.
loadtable "mytable "mytable.tbl
tables
name “word | [rows columns (sheets)] (list)
none
Creates a new table of the provided dimensions. Note that the dimensions are provided as a list of two (or three) numbers. If a number of sheets (third number) is provided, a third sheet number must also be provided in cell and setcell, and setsheet must be used to specify the sheet number for the srow, scol, replacerow, replacecolumn, row and column primitives. See setcell
newtable "mytable [3 20]
tables
table (word) | [row column (sheet)] (list) | value
none
Sets the cell in the table with the provided name to the provided value. If no sheet number is provided, setcell will default to sheet 1, if the table has multiple sheets. See cell
setcell "table [4 5] 20
setcell "table3 [4 5 2] 30
tables
name (word) | list of cell contents (list)
none
Replaces a column in the named table with the provided list of cells.
replacecolumn "table [1 2 3 4 5 6 7]
tables
name (word) | list of cell contents (list)
none
Replaces a row in the named table with the provided list of cells.
replacerow "table [1 2 3 4 5 6 7]
tables
name (word) | list of table contents (list)
none
Replaces the contents of a table with the provided list of cells. See table
replacerow "table [[1 2 3] [1 2 3] [1 2 3]]
tables
tablename | row
list
Returns the entire specified row of the specified table, formatted as a list. See column=
show row "mytable 5
tables
tablename (word) | filename (word)
none
Saves the specified table to disk using the specified filename.
savetable "mytable "mytable.tbl
tables
table (word) | [column value (variance)] (list)
list
Searches a given column in the given table for the given value, within the optionally provided variance if numeric. See srow
show scol "table [4 6 2]
tables
table (word) | sheet (number)
none
Sets the ‘sheet’ (third dimension) used by the table commands srow, scol, replacerow, replacecolumn, row and column
setsheet "table 2
tables
table (word)
sheet (number)
Returns the current sheet number for the given table. See setsheet
show sheet "table
tables
tablename (word) | column (number)
none
Sorts the specified table on the given column, low to high.
sort "table 3
tables
table (word) | [row value (variance)] (list)
list
Searches a given row in the given table for the given value, within the optionally provided variance if numeric. See scol
show srow "table [4 6 2]
tables
name (word)
list
Returns the contents of the named table as a list.
show table "mytable
tables
none
none
Returns a list of the currently defined tables.
show tables
tables
name (word)
list
Returns a list of the dimensions of the named table.
show tablesize "mytable