首页 > itarticle > ruby spreadsheet/excel生成excel

ruby spreadsheet/excel生成excel

admin 11月 12, 2020 0

Ruby生成excel文件。

require "rubygems"
require "spreadsheet/excel"
include Spreadsheet
workbook = Excel.new("test.xls")
format = Format.new
format.color = "green"
format.bold = true
worksheet = workbook.add_worksheet
worksheet.write(0, 0, "Hello", format)
worksheet.write(1, 1, ["Matz","Larry","Guido"])
workbook.close

这是doc里的例子，但是format并不能应用到"Hello"这个格子上，需要用format = workbook.add_format(:color => "green", :bold => true)才能真正生效。

PS:　这个lib只能生成，读取用parseexcel这个lib。