From: 7stud -- <bbxx789_05ss@...>
Date: 2011-05-20T07:37:54+09:00
Subject: Re: Writing formulas to excel spreadsheet

Mike Stephens wrote in post #999754:
> Have a look at :rubyonwindows.blogspot.com/search/label/excel
>
> and look for 'formula'

...which shows this:

Adding Formulae

emptyRow = 15
worksheet.Range("t#{emptyRow}")['Formula'] = 
"=(Q#{emptyRow}+L#{emptyRow}+I#{emptyRow}+S#{emptyRow})"

-- 
Posted via http://www.ruby-forum.com/.