Class ODFSpreadSheetReader

  • All Implemented Interfaces:
    AdditionalInformationHandler, Destroyable, ErrorProvider, GlobalInfoSupporter, EncodingSupporter, FileFormatHandler, LoggingLevelHandler, LoggingSupporter, OptionHandler, SizeOfHandler, Stoppable, StoppableWithFeedback, MissingValueSpreadSheetReader, MultiSheetSpreadSheetReader<SheetRange>, NoHeaderSpreadSheetReader, SpreadSheetReader, WindowedSpreadSheetReader, DataRowTypeHandler, SpreadSheetTypeHandler, Serializable

    public class ODFSpreadSheetReader
    extends AbstractMultiSheetSpreadSheetReaderWithMissingValueSupport<SheetRange>
    implements NoHeaderSpreadSheetReader, WindowedSpreadSheetReader
    Reads ODF (Open Document Format) spreadsheet files.
    If a row contains only empty cells, this is interpreted as the end of the sheet.

    -logging-level <OFF|SEVERE|WARNING|INFO|CONFIG|FINE|FINER|FINEST> (property: loggingLevel)
        The logging level for outputting errors and debugging output.
        default: WARNING
     
    -data-row-type <adams.data.spreadsheet.DataRow> (property: dataRowType)
        The type of row to use for the data.
        default: adams.data.spreadsheet.DenseDataRow
     
    -spreadsheet-type <adams.data.spreadsheet.SpreadSheet> (property: spreadSheetType)
        The type of spreadsheet to use for the data.
        default: adams.data.spreadsheet.DefaultSpreadSheet
     
    -sheets <adams.core.Range> (property: sheetRange)
        The range of sheets to load.
        default: first
        example: A range is a comma-separated list of single 1-based indices or sub-ranges of indices ('start-end'); 'inv(...)' inverts the range '...'; the following placeholders can be used as well: first, second, third, last_2, last_1, last
     
    -missing <java.lang.String> (property: missingValue)
        The placeholder for missing values.
        default: 
     
    -text-columns <java.lang.String> (property: textColumns)
        The range of columns to treat as text.
        default: 
     
    -no-header <boolean> (property: noHeader)
        If enabled, all rows get added as data rows and a dummy header will get 
        inserted.
        default: false
     
    -custom-column-headers <java.lang.String> (property: customColumnHeaders)
        The custom headers to use for the columns instead (comma-separated list);
         ignored if empty.
        default: 
     
    -first-row <int> (property: firstRow)
        The index of the first row to retrieve (1-based).
        default: 1
        minimum: 1
     
    -num-rows <int> (property: numRows)
        The number of data rows to retrieve; use -1 for unlimited.
        default: -1
        minimum: -1
     
    Author:
    fracpete (fracpete at waikato dot ac dot nz)
    See Also:
    Serialized Form