Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories API
Created by Guest
Created on Dec 5, 2017

Add ability to specify column data types when importing programmatically from Excel.

I am currently running a script which will replace data tables with excel sheets through a simple file explorer interface. However I am noticing that Spotfire is automatically guessing the data type of a column based on the first n rows of data imported. This works well in most cases, however I recently discovered that If I am importing a column which only contains whole numbers and one (or more) of these numbers is greater than 2147483647 (the integer limit), Spotfire will not read in this number as it has already specified the column type as integer.

  • Attach files