Class: Excelizer::Writer

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

Class Method Summary collapse

Class Method Details

.persist(book, file = StringIO.new) ⇒ Object



17
18
19
20
# File 'lib/excelizer/writer.rb', line 17

def self.persist(book, file=StringIO.new)
  book.write file
  file.string
end

.write(headers, records) ⇒ Object



5
6
7
8
9
10
11
12
13
14
15
# File 'lib/excelizer/writer.rb', line 5

def self.write(headers, records)
  book = Spreadsheet::Workbook.new
  sheet = book.create_worksheet
  
  sheet.row(0).push *headers
  records.each_with_index do |record, index|
    sheet.row(index + 1).push *record
  end
  
  self.persist book
end