Class: XLSXResponse

Inherits:

Object

• Object
• XLSXResponse

show all

Defined in:

backend/app/lib/reports/xlsx_response.rb

Instance Method Summary (collapse)

• - (Object) generate
• - (Object) generate_report
• - (XLSXResponse) initialize(report, params = {}) constructor

  A new instance of XLSXResponse.

• - (Object) to_stream

5
6
7
8
9
10
11
12

# File 'backend/app/lib/reports/xlsx_response.rb', line 5

def initialize(report, params = {})
  @report = report

  @p = Axlsx::Package.new
  @wb = @p.workbook

  generate_report
end

27
28
29

# File 'backend/app/lib/reports/xlsx_response.rb', line 27

def generate
  @p.to_stream
end

14
15
16
17
18
19
20
21

# File 'backend/app/lib/reports/xlsx_response.rb', line 14

def generate_report
  @wb.add_worksheet(:name => @report.class.name) do |sheet|
    sheet.add_row @report.headers
    @report.each do |row|
      sheet.add_row @report.headers.map{|h| row[h]}
    end
  end
end

23
24
25

# File 'backend/app/lib/reports/xlsx_response.rb', line 23

def to_stream
  @p.to_stream
end