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