Class: ExcelUtils::Writer

Inherits:
Object
  • Object
show all
Defined in:
lib/excel_utils/writer.rb

Constant Summary collapse

DEFAULT_SHEET_NAME = 
'Sheet1'.freeze
TIME_FORMAT = 
'%Y-%m-%dT%H:%M:%S'.freeze
EXCEL_FORMATS = 
{
  date: 'yyyy-mm-dd',
  date_time: 'yyyy-mm-dd hh:mm:ss'
}.freeze

Class Method Summary collapse

Class Method Details

.write(filename, data) ⇒ Object 



15
16
17
18
19
20
21
22
23
24
25
26
27
 
# File 'lib/excel_utils/writer.rb', line 15

def write(filename, data)
  workbook = WriteXLSX.new filename, strings_to_urls: false

  formats = add_formats workbook

  data = {DEFAULT_SHEET_NAME => data} if data.is_a? Array

  data.each do |sheet_name, sheet_data|
    add_sheet workbook, sheet_name, sheet_data, formats
  end

  workbook.close
end