Package adams.data.io.input

Class TsvSpreadSheetReader

  • All Implemented Interfaces:
    AdditionalInformationHandler, Destroyable, ErrorProvider, GlobalInfoSupporter, EncodingSupporter, FileFormatHandler, LoggingLevelHandler, LoggingSupporter, LocaleSupporter, OptionHandlingLocaleSupporter, OptionHandler, SizeOfHandler, Stoppable, StoppableWithFeedback, ChunkedSpreadSheetReader, MissingValueSpreadSheetReader, NoHeaderSpreadSheetReader, SpreadSheetReader, DataRowTypeHandler, SpreadSheetTypeHandler, Serializable
    public class TsvSpreadSheetReader
extends SimpleCsvSpreadSheetReader
    Reads TSV (tab-separated values) files.
    It is possible to force columns to be text. In that case no intelligent parsing is attempted to determine the type of data a cell has.
    For very large files, one can turn on chunking, which returns spreadsheet objects till all the data has been read. 

    -logging-level <OFF|SEVERE|WARNING|INFO|CONFIG|FINE|FINER|FINEST> (property: loggingLevel)
    The logging level for outputting errors and debugging output.
    default: WARNING
 
    -missing <adams.core.base.BaseRegExp> (property: missingValue)
    The placeholder for missing values.
    default: 
 
    -encoding <adams.core.base.BaseCharset> (property: encoding)
    The type of encoding to use when reading using a reader, leave empty for 
    default.
    default: Default
 
    -quote-char <java.lang.String> (property: quoteCharacter)
    The character to use for surrounding text cells.
    default: \"
 
    -separator <java.lang.String> (property: separator)
    The separator to use for the columns; use '\t' for tab.
    default: \\t
 
    -trim <boolean> (property: trim)
    If enabled, the content of the cells gets trimmed before added.
    default: false
 
    -text-columns <adams.core.Range> (property: textColumns)
    The range of columns to treat as text.
    default: 
    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
 
    -datetime-columns <adams.core.Range> (property: dateTimeColumns)
    The range of columns to treat as date/time msec.
    default: 
    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
 
    -datetime-format <adams.data.DateFormatString> (property: dateTimeFormat)
    The format for date/time msecs.
    default: yyyy-MM-dd HH:mm:ss
    more: http://docs.oracle.com/javase/6/docs/api/java/text/SimpleDateFormat.html
 
    -datetime-lenient <boolean> (property: dateTimeLenient)
    Whether date/time msec parsing is lenient or not.
    default: false
 
    -datetime-type <TIME|TIME_MSEC|DATE|DATE_TIME|DATE_TIME_MSEC> (property: dateTimeType)
    How to interpret the date/time data.
    default: DATE_TIME
 
    -time-zone <java.util.TimeZone> (property: timeZone)
    The time zone to use for interpreting dates/times; default is the system-wide 
    defined one.
 
    -locale <java.util.Locale> (property: locale)
    The locale to use for parsing the numbers.
    default: 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: 
 
    -chunk-size <int> (property: chunkSize)
    The maximum number of rows per chunk; using -1 will read put all data into 
    a single spreadsheet object.
    default: -1
    minimum: -1
    Author:
    FracPete (fracpete at waikato dot ac dot nz)
    See Also:
    Serialized Form