Spis poleceń › Tables — poleceń: 20
cell
Wejście: table (word) | [row column (sheet)]
Wyjście: 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
column
Wejście: table (word) | column (number)
Wyjście: list
Returns the contents of the specified column in the specified table as a list. See row
show column "table 5
erasetable
Wejście: table (word)
Wyjście: none
Erases the named table.
erase "mytable
listtables
Wejście: none
Wyjście: none
Prints the names of the currently defined tables, one per line. See tables
listtables
loadtable
Wejście: tablename (word) | filename (word)
Wyjście: none
Loads the specified filename from disk into the specified table.
loadtable "mytable "mytable.tbl
newtable
Wejście: name "word | [rows columns (sheets)] (list)
Wyjście: none
Creates a new table container of the provided dimensions. The name of the table may not be used by another container (table or otherwise). 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]
putcell
Także: setcell
Wejście: table (word) | [row column (sheet)] (list) | value
Wyjście: 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
replacecolumn
Wejście: name (word) | list of cell contents (list)
Wyjście: none
Replaces a column in the named table with the provided list of cells.
replacecolumn "table [1 2 3 4 5 6 7]
replacerow
Wejście: name (word) | list of cell contents (list)
Wyjście: none
Replaces a row in the named table with the provided list of cells.
replacerow "table [1 2 3 4 5 6 7]
replacetable
Wejście: name (word) | list of table contents (list)
Wyjście: 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]]
row
Wejście: tablename | row
Wyjście: list
Returns the entire specified row of the specified table, formatted as a list. See column=
show row "mytable 5
savetable
Wejście: tablename (word) | filename (word)
Wyjście: none
Saves the specified table to disk using the specified filename.
savetable "mytable "mytable.tbl
scol
Wejście: table (word) | [column value (variance)] (list)
Wyjście: 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]
setsheet
Wejście: table (word) | sheet (number)
Wyjście: none
Sets the 'sheet' (third dimension) used by the table commands srow, scol, replacerow, replacecolumn, row and column
setsheet "table 2
sheet
Wejście: table (word)
Wyjście: sheet (number)
Returns the current sheet number for the given table. See setsheet
show sheet "table
sort
Wejście: tablename (word) | column (number)
Wyjście: none
Sorts the specified table on the given column, low to high.
sort "table 3
srow
Wejście: table (word) | [row value (variance)] (list)
Wyjście: 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]
table
Wejście: name (word)
Wyjście: list
Returns the contents of the named table as a list.
show table "mytable
tables
Wejście: none
Wyjście: none
Returns a list of the currently defined tables.
show tables
tablesize
Wejście: name (word)
Wyjście: list
Returns a list of the dimensions of the named table.
show tablesize "mytable