Writing formulas to excel spreadsheet

Discussion in 'Ruby' started by ampclj9@hotmail.com James, May 19, 2011.

  1.  James

    James Guest

    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/.
    James, May 19, 2011
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. FSD
    Replies:
    0
    Views:
    1,189
  2. Kevin Howe
    Replies:
    6
    Views:
    226
    Kevin Howe
    Feb 6, 2005
  3. Will James
    Replies:
    22
    Views:
    631
    Will James
    May 26, 2011
  4. qazmlp
    Replies:
    2
    Views:
    140
    Ben Morrow
    Nov 17, 2004
  5. Yousaf
    Replies:
    1
    Views:
    103
    Bart Van der Donck
    Apr 10, 2007
Loading...

Share This Page