Contents

#!/usr/bin/env ruby

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

5 entries across 5 versions & 1 rubygems

Version	Path
writeexcel-1.0.9	examples/store_formula.rb
writeexcel-1.0.8	examples/store_formula.rb
writeexcel-1.0.7	examples/store_formula.rb
writeexcel-1.0.6	examples/store_formula.rb
writeexcel-1.0.5	examples/store_formula.rb