Detailed Description of Excel File Reader
Reads rows of table from one sheet of an Excel spreadsheet
file.
During reading from cells, data conversion is performed according
to following rules:
- if destination
column is string type, numeric cell is converted to their string representation,
boolean cell is converted to "true" or "false" string.
- if destination
column is numeric type (integer, long or float), text cell is converted
to this type if possible, otherwise null is assigned, boolean cell
is converted to 1 or 0. Text as number can contain thousand separators,
decimal point, sign and exponent, for example "1.234e+4" can be
successfully converted to integer value 12340. Characters "," and
"." is assumed as thousand or decimal point, so, for example values
"-71,716.23" and "-71.716,23" can be successfully converted to the
same float value -71716.23.
- if destination
column is boolean type, text cell with value "true" or "1" or "false"
or "0" is converted, numeric cell with value 1 or 0 is converted,
otherwise null is assigned.
- if destination
column is day or datetime type, text cell is parsed for date according
to pattern "yyyy-MM-dd[t[hh:mm:ss]]", otherwise null is assigned.