Class: Backframe::Response::Adapter::Xlsx

Inherits:
Object
  • Object
show all
Defined in:
lib/backframe/response/adapter/xlsx.rb

Class Method Summary collapse

Class Method Details

.render(collection, fields) ⇒ Object 



13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 
# File 'lib/backframe/response/adapter/xlsx.rb', line 13

def render(collection, fields)
  filename = SecureRandom.hex(32).to_s.upcase[0,16]
  workbook = WriteXLSX.new(filename)
  worksheet = workbook.add_worksheet
  fields.array.each_with_index do |field, i|
    worksheet.write_string(0, i, field[:label])
  end
  collection.records.each_with_index do |item, i|
    serialized = ActiveModelSerializers::SerializableResource.new(item).serializable_hash
    fields.array.each_with_index do |field, j|
      value = Backframe::Response::Record.get_value(serialized, field[:key])
      worksheet.write_string((i + 1), j, value.to_s)
    end
  end
  workbook.close
  output = open(filename).read
  File.unlink(filename)
  output
end