From: Will James <ampclj9@...>
Date: 2011-05-20T13:42:11+09:00
Subject: Re: Writing formulas to excel spreadsheet

7stud -- wrote in post #999761:
> 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})"

Thanks, guys. However, the above seems to require win32ole, for which, 
if I'm not mistaken, you need office to be installed on the system.

Is there a way to do this with just the spreadsheet gem (i.e. just 
require spreadsheet)?

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