Method: Workbook::Readers::XlsShared#strftime_to_ms_format

Defined in:
lib/workbook/readers/xls_shared.rb

#strftime_to_ms_format(numberformat) ⇒ String?

Converts standard (ruby/C++/unix/…) strftime formatting to MS’s formatting

Parameters:

  • numberformat (String, nil) —

    (nil returns nil)

Returns:

  • (String, nil) 


85
86
87
88
 
# File 'lib/workbook/readers/xls_shared.rb', line 85

def strftime_to_ms_format numberformat
  return nil if numberformat.nil?
  return numberformat.gsub('%Y','yyyy').gsub('%A','dddd').gsub('%B','mmmm').gsub('%a','ddd').gsub('%b','mmm').gsub('%y','yy').gsub('%d','dd').gsub('%m','mm').gsub('%y','y').gsub('%y','%%y').gsub('%e','d')
end