Sha256: 8c33bbba225eef5cbb3a0f50b4302f91b1ba9439b65693649bcd18e76b63f878
Contents?: true
Size: 375 Bytes
Versions: 21
Compression:
Stored size: 375 Bytes
Contents
#!/usr/bin/env ruby
require 'rubygems'
require 'writeexcel'
# Create a new workbook called simple.xls and add a worksheet
workbook = WriteExcel.new('store_formula.xls')
worksheet = workbook.add_worksheet()
formula = worksheet.store_formula('=A1 * 3 + 50')
(0 .. 999).each do |row|
worksheet.repeat_formula(row, 1, formula, nil, 'A1', "A#{row + 1}")
end
workbook.close
Version data entries
21 entries across 21 versions & 3 rubygems