Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Ruby > Writing formulas to excel spreadsheet

Reply
Thread Tools

Writing formulas to excel spreadsheet

 
 
ampclj9@hotmail.com James
Guest
Posts: n/a
 
      05-19-2011
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/.

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Writing formulas to excel spreadsheet Will James Ruby 22 05-26-2011 05:46 PM
[ANN] LXL (Like Excel) 0.1.0 - A mini-language that mimics Microsoft Excel formulas. Kevin Howe Ruby 6 02-06-2005 10:05 PM
Save excel including embedded Formulas, Comments etc. qazmlp Perl Misc 2 11-17-2004 05:46 PM
Re: Writing mathematical formulas without using Word Equation Editor =?iso-8859-1?Q?Andr=E9_P=F6nitz?= Computer Support 0 06-27-2003 08:30 AM
Re: Writing mathematical formulas without using Word Equation Editor =?iso-8859-1?Q?Andr=E9_P=F6nitz?= Computer Support 0 06-27-2003 08:26 AM



Advertisments