DeleteColumn(int Index)
Exception
Deletes the specified column from the table.
Parameters:
Index
Throws: Exception
DeleteRow(int Row)
Exception
Delete the specified row. If this table is an attribute table within a
layer this function will also delete the feature associated with the row.
Parameters:
Row - Row index to delete.
Throws: Exception
STColumn GetColumn(int Index)
Return the specified column from the table.
Parameters:
Index
Returns:
int GetColumnIndexByName(String Heading)
Return the first column that has a matching heading
Parameters:
Index
Returns:
GregorianCalendar GetDateCell(int RowIndex,int ColumnIndex)
Exception
Returns the value of the specified cell. Note that this is one of the few
places where the "y" value (the RowIndex) is specified before the "x"
index. This is the standard for spreadsheets and is followed here.
Parameters:
RowIndex - Row of the cell to update
ColumnIndex - Column of the cell to update
Returns: - The current value in the cell if it is a String. Otherwise
Double GetDoubleCell(int RowIndex,int ColumnIndex)
Exception
Returns the value of the specified cell. Note that this is one of the few
places where the "y" value (the RowIndex) is specified before the "x"
index. This is the standard for spreadsheets and is followed here.
Parameters:
RowIndex - Row of the cell to update
ColumnIndex - Column of the cell to update
Returns: - The current value in the cell if it is a String. Otherwise
String GetHeading(int ColumnIndex)
Return the heading for the specified column index.
Parameters:
ColumnIndex
Returns:
long GetLongCell(int RowIndex,int ColumnIndex)
Exception
Returns the value of the specified cell. Note that this is one of the few
places where the "y" value (the RowIndex) is specified before the "x"
index. This is the standard for spreadsheets and is followed here.
Parameters:
RowIndex - Row of the cell to update
ColumnIndex - Column of the cell to update
Returns: - The current value in the cell if it is a String. Otherwise
int GetNumColumns()
Return the number of columns in the table.
Returns:
int GetNumRows()
Return the number of rows in the table.
Returns:
Object GetObjectCell(int RowIndex,int ColumnIndex)
Exception
Returns the value of the specified cell. Note that this is one of the few
places where the "y" value (the RowIndex) is specified before the "x"
index. This is the standard for spreadsheets and is followed here.
Parameters:
RowIndex - Row of the cell to update
ColumnIndex - Column of the cell to update
Returns: - The current value in the cell if it is a String. Otherwise
String GetStringCell(int RowIndex,int ColumnIndex)
Exception
Returns the value of the specified cell. Note that this is one of the few
places where the "y" value (the RowIndex) is specified before the "x"
index. This is the standard for spreadsheets and is followed here.
Parameters:
RowIndex - Row of the cell to update
ColumnIndex - Column of the cell to update
Returns: - The current value in the cell if it is a String. Otherwise
int InsertColumn(int Index,COLUMN_TYPE Type,String Heading)
Exception
Inserts a column of the specified type into the table. The column will
contain blanks for strings, 0s for numeric values.
Parameters:
Heading - heading for the column
Index column index, -1 for the end
Type - One of the standard STColumn.TYPE values: STRING,DOUBLE,INTEGER,DATE,BLOB
Returns:
int InsertRow(int Row)
Exception
Inserts a new row at the specified index.
Parameters:
Row - Location to insert the new row. 0 will insert a row at the
SetCell(int RowIndex,int ColumnIndex,Double Value)
Exception
Set the cell to the specified value. Note that this is one of the few
places where the "y" value (the RowIndex) is specified before the "x"
index. This is the standard for spreadsheets and is followed here.
Parameters:
RowIndex - Row of the cell to update
ColumnIndex - Column of the cell to update
Value - Value to place in the cell.
Throws: Exception
SetCell(int RowIndex,int ColumnIndex,GregorianCalendar Value)
Exception
Set the cell to the specified value. Note that this is one of the few
places where the "y" value (the RowIndex) is specified before the "x"
index. This is the standard for spreadsheets and is followed here.
Parameters:
RowIndex - Row of the cell to update
ColumnIndex - Column of the cell to update
Value - Value to place in the cell.
Throws: Exception
SetCell(int RowIndex,int ColumnIndex,String Value)
Exception
Set the cell to the specified value. Note that this is one of the few
places where the "y" value (the RowIndex) is specified before the "x"
index. This is the standard for spreadsheets and is followed here.
Parameters:
RowIndex - Row of the cell to update
ColumnIndex - Column of the cell to update
Value - Value to place in the cell.
Throws: Exception
SetCell(int RowIndex,int ColumnIndex,int Value)
Exception
Set the cell to the specified value. Note that this is one of the few
places where the "y" value (the RowIndex) is specified before the "x"
index. This is the standard for spreadsheets and is followed here.
Parameters:
RowIndex - Row of the cell to update
ColumnIndex - Column of the cell to update
Value - Value to place in the cell.
Throws: Exception
SetColumnType(int Index,COLUMN_TYPE New)
Exception
Set the type of column. This can be used to convert the data from one
type to another. It is recommended to maintain large tables in their
native type (e.g. floating point values as DOUBLEs instead of STRINGs).
This will improve the performance of the program for large datasets.
Parameters:
Index
New
Throws: Exception
SetHeading(int ColumnIndex,String Name)
Exception
Sets the heading for a column in the table.
Parameters:
ColumnIndex
Name -
SetNumRows(int NewNumRows)
Exception
Sets the number of rows to the specified value.
Parameters:
NewNumRows -
SetSort(int ColumnIndex,boolean NewAscending)
Exception
Adds a sort to the table.
Parameters:
ColumnIndex - column index to sort on or -1 to cancel the sort
NewAscending
SetSortToSelected()
Sorts the table to have selected items on top
