Class: Dorsale::Serializers::XLSX

Inherits:
Base
  • Object
show all
Defined in:
app/serializers/dorsale/serializers/xlsx.rb

Instance Attribute Summary

Attributes inherited from Base

#data, #options

Instance Method Summary collapse

Methods inherited from Base

#initialize

Constructor Details

This class inherits a constructor from Dorsale::Serializers::Base

Instance Method Details

#render_file(file_path) ⇒ Object 



8
9
10
 
# File 'app/serializers/dorsale/serializers/xlsx.rb', line 8

def render_file(file_path)
  xlsx.serialize(file_path)
end

#render_inline ⇒ Object 



4
5
6
 
# File 'app/serializers/dorsale/serializers/xlsx.rb', line 4

def render_inline
  xlsx.to_stream.read.force_encoding("BINARY")
end

#xlsx ⇒ Object 



12
13
14
15
16
17
18
19
20
21
22
23
 
# File 'app/serializers/dorsale/serializers/xlsx.rb', line 12

def xlsx
  @xlsx ||= Axlsx::Package.new do |p|
    p.workbook.add_worksheet do |sheet|
      data.each do |line|
        types = [:string] * line.length
        sheet.add_row(line, types: types)
      end
    end

    p.use_shared_strings = true
  end
end