Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.ruby > #4767
| Path | csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!gegeweb.org!talisker.lacave.net!lacave.net!not-for-mail |
|---|---|
| From | "ampclj9@hotmail.com James" <ampclj9@hotmail.com> |
| Newsgroups | comp.lang.ruby |
| Subject | Writing formulas to excel spreadsheet |
| Date | Thu, 19 May 2011 11:16:25 -0500 |
| Organization | Service de news de lacave.net |
| Lines | 14 |
| Message-ID | <abeadb4585eca9bd4748d277fc1d2dbd@ruby-forum.com> (permalink) |
| NNTP-Posting-Host | bristol.highgroove.com |
| Content-Type | text/plain; charset=UTF-8 |
| Content-Transfer-Encoding | 7bit |
| X-Trace | talisker.lacave.net 1305821801 30757 65.111.164.187 (19 May 2011 16:16:41 GMT) |
| X-Complaints-To | abuse@lacave.net |
| NNTP-Posting-Date | Thu, 19 May 2011 16:16:41 +0000 (UTC) |
| 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 | 383475 |
| X-Ml-Name | ruby-talk |
| X-Rubymirror | Yes |
| X-Ruby-Talk | <abeadb4585eca9bd4748d277fc1d2dbd@ruby-forum.com> |
| Xref | x330-a1.tempe.blueboxinc.net comp.lang.ruby:4767 |
Show key headers only | View raw
Hi, everyone. I've just started using ruby a couple of days ago, and I've been using it to read data from text files and write to excel spreadsheets. I also need to be able to write formulas to spreadsheets, but when I open the excel file, the formula is in there without having been evaluated - for example, the cell will appear as "=A1+A58+A112" instead of whatever the value of that sum happens to be. If I click on the cell and hit "enter," the formula will evaluate, but it does not do so automatically. Is there any way to get ruby to force excel to evaluate? Thanks! -- Posted via http://www.ruby-forum.com/.
Back to comp.lang.ruby | Previous | Next — Next in thread | Find similar | Unroll thread
Writing formulas to excel spreadsheet "ampclj9@hotmail.com James" <ampclj9@hotmail.com> - 2011-05-19 11:16 -0500 Re: Writing formulas to excel spreadsheet Mahendra Pal Verma <mahendra@iie.org.mx> - 2011-05-19 12:12 -0500
csiph-web