csv・Excelファイルの扱い方

目次
１、CSVファイル
２、Excelファイル

CSVファイルに書き出す

require "csv"

bom = %w(EF BB BF).map{|e|e.hex.chr}.join
csv_file = CSV.generate(bom) do |csv|
    csv << ["id","title","url"]
end

File.open("list.csv","w") do |file|
    file.write(csv_file)
end

Excelファイルに書き出す

require "rubyXL"
require "rubyXL/convenience_methods/cell"
require "rubyXL/convenience_methods/workbook"

wb = RubyXL::Workbook.new

sheet = wb[0]

sheet.add_cell(0,0,"id")
sheet.add_cell(0,1,"name")
sheet.add_cell(0,2,"url")
sheet.add_cell(1,0,"12")
sheet.add_cell(1,1,"foo")
sheet.add_cell(1,2,"sum@example.com")
sheet.add_cell(2,0,"18")
sheet.add_cell(2,1,"bar")
sheet.add_cell(2,2,"foo@example.com")

wb.write('outlook.xlsx')