Class: ExcelUtils::Writer

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

Constant Summary collapse

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

Class Method Summary collapse

Class Method Details

.write(filename, data) ⇒ Object 



13
14
15
16
17
18
19
20
21
22
23
 
# File 'lib/excel_utils/writer.rb', line 13

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

  formats = add_formats workbook

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

  workbook.close
end