pythonicrubyist / creek

Ruby library for parsing large Excel files.
http://rubygems.org/gems/creek
MIT License
386 stars 109 forks source link

In the Creek::Styles::Converter class it is said that type can also be determined by a style, however there is no way from the Creek::Sheet Class to assign a style to the type #92

Closed rferrando closed 3 years ago

rferrando commented 4 years ago

Hi, In the Creek::Styles::Converter class it is said that type can also be determined by a style, however beyond those established in constant DATE_TYPES, there is no way from the Creek::Sheet class to assign a style to the type. In my case, I think because an older version of nokogiri gem, cells with Large Numbers based strings (and format as text) are retrieved as nodes with type 'n' (as numbers) and not 's' (strings), so they are converted into float. However the book styles retrieved from Creek::Styles::StyleTypes, determine those cells as :unsupported and if there was a way to explicitly tell the converter to use the style and not the type, the converter's own functionality would make it work correctly.

Kind Regards,