Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!aioe.org!feeder.news-service.com!de-l.enfer-du-nord.net!feeder2.enfer-du-nord.net!feeder1.enfer-du-nord.net!talisker.lacave.net!lacave.net!not-for-mail From: 7stud -- Newsgroups: comp.lang.ruby Subject: Re: Writing formulas to excel spreadsheet Date: Thu, 19 May 2011 17:37:54 -0500 Organization: Service de news de lacave.net Lines: 16 Message-ID: References: <267f0e6b73bdfa961dbda489c97c181d@ruby-forum.com> <7ee671500075e2f3292be2091ec54ac4@ruby-forum.com> NNTP-Posting-Host: bristol.highgroove.com Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Trace: talisker.lacave.net 1305845628 74591 65.111.164.187 (19 May 2011 22:53:48 GMT) X-Complaints-To: abuse@lacave.net NNTP-Posting-Date: Thu, 19 May 2011 22:53:48 +0000 (UTC) In-Reply-To: <7ee671500075e2f3292be2091ec54ac4@ruby-forum.com> X-Received-From: This message has been automatically forwarded from the ruby-talk mailing list by a gateway at comp.lang.ruby. If it is SPAM, it did not originate at comp.lang.ruby. Please report the original sender, and not us. Thanks! For more details about this gateway, please visit: http://blog.grayproductions.net/categories/the_gateway X-Mail-Count: 383496 X-Ml-Name: ruby-talk X-Rubymirror: Yes X-Ruby-Talk: Xref: x330-a1.tempe.blueboxinc.net comp.lang.ruby:4788 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/.