Module: Xls

Defined in:
lib/xls/file.rb,
lib/xls/file/version.rb

Defined Under Namespace

Modules: File Classes: Error

Class Method Summary collapse

Class Method Details

.formatted_excel_data(row) ⇒ Object 



23
24
25
 
# File 'lib/xls/file.rb', line 23

def self.formatted_excel_data(row)
  row.collect{|k, v| [v]}.flatten!
end

.generate_xls(data, headers) ⇒ Object 



6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
 
# File 'lib/xls/file.rb', line 6

def self.generate_xls(data, headers)
  package = Axlsx::Package.new
  work_sheet = package.workbook.add_worksheet(name: 'work_book')
  work_sheet.add_row headers
  unless data.is_a? Array
    data = data.as_json
  end
  data.each do |row|
    formatted_row = formatted_excel_data(row)
    work_sheet.add_row formatted_row
  end
  filename = "xls-file-#{Date.today.strftime("%dth %b %Y")}"
  path = "tmp/#{filename}"
  package.use_shared_strings = true
  package.serialize(path)
  return path
end

.test ⇒ Object 



26
27
28
 
# File 'lib/xls/file.rb', line 26

def self.test
  puts "Cheers!! xls-file installed successfully"
end