module Roo::Excelx::Format

Constants

EXCEPTIONAL_FORMATS
STANDARD_FORMATS

Public Class Methods

to_type(format) click to toggle source
# File lib/roo/excelx.rb, line 53
def to_type(format)
  format = format.to_s.downcase
  if type = EXCEPTIONAL_FORMATS[format]
    type
  elsif format.include?('#')
    :float
  elsif !format.match(/d+(?![\]])/).nil? || format.include?('y')
    if format.include?('h') || format.include?('s')
      :datetime
    else
      :date
    end
  elsif format.include?('h') || format.include?('s')
    :time
  elsif format.include?('%')
    :percentage
  else
    :float
  end
end

Private Instance Methods

to_type(format) click to toggle source
# File lib/roo/excelx.rb, line 53
def to_type(format)
  format = format.to_s.downcase
  if type = EXCEPTIONAL_FORMATS[format]
    type
  elsif format.include?('#')
    :float
  elsif !format.match(/d+(?![\]])/).nil? || format.include?('y')
    if format.include?('h') || format.include?('s')
      :datetime
    else
      :date
    end
  elsif format.include?('h') || format.include?('s')
    :time
  elsif format.include?('%')
    :percentage
  else
    :float
  end
end