Integers coerce to Floats when creating a dataset from an xls document about incanter

[MawiraIke]

Seems like there is a bug in the read-xls function. After altering my xls file to include other data types such as multiple-decimal floats, nil and some empty fields it seems like the dataset created contains a lot of wrong data as shown by the image below. The data on the left is the original data, the window shows incanters read dataset.

[joinr]

Just perusing. Yea, the underlying format in Excel is that everything is a float (I believe). So values from apache POI are going to coerce to floats. I handle this via some additional parsing by default. I think there may be specifically tagged types of integers in Excel, but they're stored as floats maybe.

[MawiraIke]

Thank you for that. Seems like Apache POI doesnt have a supported Integer type as shown here https://poi.apache.org/apidocs/dev/org/apache/poi/hsmf/datatypes/Types I would also be glad to know why Incanter yields wrong values when multiple data types are used as mentioned above.

[MawiraIke]

I am going to close this issue because i cannot reproduce the wrong values error after trying with new excel files, even with multiple data types.