class |
AbstractInPlaceSpreadSheetConversion |
Ancestor for spreadsheet conversion that allow working on the incoming data
rather than on a copy (to conserve memory).
|
class |
AbstractSpreadSheetColumnConverter<T> |
Ancestor for column converter schemes.
|
class |
ConvertSpreadSheetRows |
Converts the rows in the spreadsheet into a new format.
|
class |
ExcelDoubleColumnToDate |
Converts the specified double column to a date column.
|
class |
ExcelDoubleColumnToDateTime |
Converts the specified double column to a date/time column.
|
class |
RenameSpreadSheet |
Renames the spreadsheet.
|
class |
RenameSpreadSheetColumn |
Renames a single column in a spreadsheet.
|
class |
SpreadSheetAddFormulaColumn |
Adds a column with a user-supploed formula for the specified rows.
|
class |
SpreadSheetAddFormulaRow |
Adds a row with a user-supplied formula for the specified columns.
|
class |
SpreadSheetAddRowID |
Adds an ID column to the spreadsheet, using the row index as value.
|
class |
SpreadSheetAddSumColumn |
Adds a column with 'sum' formulas for the specified rows.
|
class |
SpreadSheetAddSumRow |
Adds a row with 'sum' formulas for the specified columns.
|
class |
SpreadSheetAnyColumnToString |
Converts the specified spreadsheet column from any type to string.
|
class |
SpreadSheetBinarize |
Binarizes the non-numeric columns in the selected column range by creating a new column for each of the labels.
|
class |
SpreadSheetDoubleColumnToLong |
Converts the specified spreadsheet column from double to long.
Simply uses the Double's 'longValue()' method.
|
class |
SpreadSheetDoubleColumnToString |
Converts the specified spreadsheet double column to string.
|
class |
SpreadSheetJoinColumns |
Merges two or more columns in a spreadsheet into a single column.
Columns can be out-of-order.
|
class |
SpreadSheetLongColumnToDouble |
Converts the specified spreadsheet column from long to double.
Simply uses the cell's 'toDouble()' method.
|
class |
SpreadSheetMaterializeFormulas |
Finds cells with formulas in a spreadsheet and replaces the cell content with the value calculated by the formula.
|
class |
SpreadSheetObjectColumnToString |
Converts the specified spreadsheet column from the object type to string.
|
class |
SpreadSheetSplitColumn |
Splits the string representation of the cells of a column into multiple columns using a regular expression.
|
class |
SpreadSheetStringColumnToBoolean |
Converts the specified spreadsheet column from string to boolean.
|
class |
SpreadSheetStringColumnToDate |
Converts the specified spreadsheet column from string to date, according to the provided format.
For more information on the format, see Javadoc of 'java.text.SimpleDateFormat' class:
http://docs.oracle.com/javase/6/docs/api/java/text/SimpleDateFormat.html
Valid options are:
|
class |
SpreadSheetStringColumnToDateTime |
Converts the specified spreadsheet column from string to date/time, according to the provided format.
For more information on the format, see Javadoc of 'java.text.SimpleDateFormat' class:
http://docs.oracle.com/javase/6/docs/api/java/text/SimpleDateFormat.html
Valid options are:
|
class |
SpreadSheetStringColumnToDateTimeMsec |
Converts the specified spreadsheet column from string to date/time/msec, according to the provided format.
For more information on the format, see Javadoc of 'java.text.SimpleDateFormat' class:
http://docs.oracle.com/javase/6/docs/api/java/text/SimpleDateFormat.html
Valid options are:
|
class |
SpreadSheetStringColumnToDouble |
Converts the specified spreadsheet column from string to double, according to the provided format.
For more information on the format, see Javadoc of 'java.text.DecimalFormat' class:
http://docs.oracle.com/javase/6/docs/api/java/text/DecimalFormat.html
Valid options are:
|
class |
SpreadSheetStringColumnToLong |
Converts the specified spreadsheet column from string to long, according to the provided format.
For more information on the format, see Javadoc of 'java.text.DecimalFormat' class:
http://docs.oracle.com/javase/6/docs/api/java/text/DecimalFormat.html
Valid options are:
|
class |
SpreadSheetStringColumnToObject |
Converts the specified spreadsheet column from string to an object, using the specified handler.
|
class |
SpreadSheetStringColumnToTime |
Converts the specified spreadsheet column from string to time, according to the provided format.
For more information on the format, see Javadoc of 'java.text.SimpleTimeFormat' class:
http://docs.oracle.com/javase/6/docs/api/java/text/SimpleDateFormat.html
|
class |
SpreadSheetStringColumnToTimeMsec |
Converts the specified spreadsheet column from string to time/msec, according to the provided format.
For more information on the format, see Javadoc of 'java.text.SimpleTimeFormat' class:
http://docs.oracle.com/javase/6/docs/api/java/text/SimpleDateFormat.html
|
class |
SpreadSheetUniqueColumnNames |
Ensures that column names are unique.
|
class |
SpreadSheetUseRowAsHeader |
Uses the values of the specified data row for the header.
|
class |
TransposeSpreadSheet |
Transposes a spreadsheet, i.e., swaps columns with rows.
|