module Csv2excel

Constants

VERSION

Public Class Methods

to_xlsx(file:) click to toggle source

Convert csv to xlsx

@param [String] file csv file path

# File lib/csv2excel.rb, line 11
def self.to_xlsx(file:)
  Axlsx::Package.new do |p|
    p.workbook.add_worksheet(name: 'Sheet1') do |sheet|
      CSV.foreach file do |row|
        sheet.add_row row
      end
    end
    p.serialize("#{File.dirname(file)}/#{File.basename(file, '.csv')}.xlsx")
  end
end