All integers are treated as Float data type by default in .xls

[yrmallu]

For phone numbers and other fields it's showing Float datatype

undefined method `split' for 99999999.0:Float

[ksugiarto]

You can change it to Integer actually, can you provide your full problem? I faced the same kind of problem, but now it solved.

[emerson-h]

There are big changes coming to how typecasting is managed. Stay tuned for updates!

[deivid-rodriguez]

Same problem here, any progress?

[petertellgren]

Same problem here too.
P.S. I've seen the promise of changes pertaining to this and similar issues but very little in actual merges or commits. Is there some blocking issue where one can assist or help out in any way?

[grumpit]

FWIW this seems to be an issue with the spreadsheet gem, as it's noted right in the README on its page: https://github.com/zdavatz/spreadsheet

[stevendaniels]

While this issue is related to xls support, which has been moved to the roo-xls gem, the behavior still exists in the master branch of Roo.

Fixing the way types are managed would be a big change.

[stevendaniels]

#240 resolves this issue. Add the following to your gemfile to install it.

gem 'roo', git: 'git://github.com/roo-rb/roo.git' 

I will work on publishing a new version of the gem to Rubygems this weekend.