Référence › Tables — 20 commandes
cell
Entrée: table (word) | [row column (sheet)]
Sortie: 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
Entrée: table (word) | column (number)
Sortie: list
Returns the contents of the specified column in the specified table as a list. See row
show column "table 5
erasetable
Entrée: table (word)
Sortie: none
Erases the named table.
erase "mytable
listtables
Entrée: none
Sortie: none
Prints the names of the currently defined tables, one per line. See tables
listtables
loadtable
Entrée: tablename (word) | filename (word)
Sortie: none
Loads the specified filename from disk into the specified table.
loadtable "mytable "mytable.tbl
newtable
Entrée: name "word | [rows columns (sheets)] (list)
Sortie: 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
Aussi: setcell
Entrée: table (word) | [row column (sheet)] (list) | value
Sortie: 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
Entrée: name (word) | list of cell contents (list)
Sortie: none
Replaces a column in the named table with the provided list of cells.
replacecolumn "table [1 2 3 4 5 6 7]
replacerow
Entrée: name (word) | list of cell contents (list)
Sortie: none
Replaces a row in the named table with the provided list of cells.
replacerow "table [1 2 3 4 5 6 7]
replacetable
Entrée: name (word) | list of table contents (list)
Sortie: 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
Entrée: tablename | row
Sortie: list
Returns the entire specified row of the specified table, formatted as a list. See column=
show row "mytable 5
savetable
Entrée: tablename (word) | filename (word)
Sortie: none
Saves the specified table to disk using the specified filename.
savetable "mytable "mytable.tbl
scol
Entrée: table (word) | [column value (variance)] (list)
Sortie: 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
Entrée: table (word) | sheet (number)
Sortie: none
Sets the 'sheet' (third dimension) used by the table commands srow, scol, replacerow, replacecolumn, row and column
setsheet "table 2
sheet
Entrée: table (word)
Sortie: sheet (number)
Returns the current sheet number for the given table. See setsheet
show sheet "table
sort
Entrée: tablename (word) | column (number)
Sortie: none
Sorts the specified table on the given column, low to high.
sort "table 3
srow
Entrée: table (word) | [row value (variance)] (list)
Sortie: 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
Entrée: name (word)
Sortie: list
Returns the contents of the named table as a list.
show table "mytable
tables
Entrée: none
Sortie: none
Returns a list of the currently defined tables.
show tables
tablesize
Entrée: name (word)
Sortie: list
Returns a list of the dimensions of the named table.
show tablesize "mytable