Module: Csv2Xlsx

Defined in:
lib/csv2xlsx.rb,
lib/csv2xlsx/version.rb

Constant Summary collapse

VERSION =
"0.0.1"

Class Method Summary collapse

Class Method Details

.run(args) ⇒ Object



6
7
8
9
10
11
12
13
14
15
16
17
18
19
# File 'lib/csv2xlsx.rb', line 6

def run(args)
  dest = args.shift
  p = Axlsx::Package.new
  wb = p.workbook
  args.each do |csv_file|
    sheet_name = File.basename(csv_file, File.extname(csv_file))
    wb.add_worksheet(name: sheet_name) do |sheet|
      CSV.foreach(csv_file) do |row|
        sheet.add_row row
      end
    end
  end
  p.serialize(dest)
end