andyj/RailoExtensionProvider — Issue #36:  ENH: Add basic data type detection for SpreadSheetAddRows
Author: Leigh-
Created: 2011-11-27 23:36:30+00:00
State: open

SpreadSheetAddRows treats all values/cells as strings. This makes it difficult to apply formatting numeric or date/time cells. This function should automatically detect the data types from query metadata. Then create the proper cell type for dates and numbers, as well as apply a default format to date/time values:

__Query Column Types:__

__DATE__
- CELL_TYPE_NUMERIC
- Default Format: *m/d/yy*

__TIMESTAMP__
- CELL_TYPE_NUMERIC
- Default Format: *m/d/yy hh:mm:ss*

__TIME__
- CELL_TYPE_NUMERIC
- Default Format: *hh:mm:ss*

__DECIMAL,BIGINT,NUMERIC,DOUBLE,FLOAT,INTEGER,REAL,SMALLINT,TINYINT__
- CELL_TYPE_NUMERIC
- None. Let Excel determine the format

__BOOLEAN,BIT__
- CELL_TYPE_BOOLEAN
- None. Let Excel determine the format

__STRING__
- CELL_TYPE_STRING
- n/a