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.