require 'rubygems'
require 'writeexcel'
workbook = Spreadsheet::WriteExcel.new('ruby.xls')
worksheet = workbook.add_worksheet
worksheet2 = workbook.add_worksheet
format = workbook.add_format
format.set_bold
format.set_color('red')
format.set_align('right')
worksheet.write(1, 1, 'Hi Excel.', format)
worksheet.write(2, 1, 'Hi Ruby.')
worksheet.write('B4', 3.14159)
worksheet.write('B5', '=SIN(B4/4)')
workbook.close
近期评论