Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.ruby > #4768

Writing formulas to excel spreadsheet

Show all headers | 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+A114"
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

Thread

Writing formulas to excel spreadsheet Will James <ampclj9@hotmail.com> - 2011-05-19 11:22 -0500
  Re: Writing formulas to excel spreadsheet Mike Stephens <rubfor@recitel.net> - 2011-05-19 16:58 -0500
    Re: Writing formulas to excel spreadsheet 7stud -- <bbxx789_05ss@yahoo.com> - 2011-05-19 17:37 -0500
      Re: Writing formulas to excel spreadsheet Will James <ampclj9@hotmail.com> - 2011-05-19 23:42 -0500
        Re: Writing formulas to excel spreadsheet Chuck Remes <cremes.devlist@mac.com> - 2011-05-20 09:28 -0500
        Saving Electricty - Using a Blackboard? Mike Stephens <rubfor@recitel.net> - 2011-05-20 12:41 -0500
          Re: Saving Electricty - Using a Blackboard? Will James <ampclj9@hotmail.com> - 2011-05-20 13:19 -0500
  Matz never said Microsoft was the Devil Incarnate. (or did he?) Mike Stephens <rubfor@recitel.net> - 2011-05-20 16:36 -0500
    Re: Matz never said Microsoft was the Devil Incarnate. (or did he?) Daniel Berger <djberg96@gmail.com> - 2011-05-20 17:02 -0500
      Re: Matz never said Microsoft was the Devil Incarnate. (or did he?) Will James <ampclj9@hotmail.com> - 2011-05-20 21:28 -0500
        Re: Matz never said Microsoft was the Devil Incarnate. (or did he?) Mike Stephens <rubfor@recitel.net> - 2011-05-21 16:14 -0500
          Re: Matz never said Microsoft was the Devil Incarnate. (or did he?) Damjan Rems <d_rems@yahoo.com> - 2011-05-23 15:18 -0500
            Re: Matz never said Microsoft was the Devil Incarnate. (or did he?) Will James <ampclj9@hotmail.com> - 2011-05-24 11:45 -0500
          Re: Matz never said Microsoft was the Devil Incarnate. (or did he?) Mike Stephens <rubfor@recitel.net> - 2011-05-23 16:38 -0500
            Re: Matz never said Microsoft was the Devil Incarnate. (or did he?) Michal Suchanek <hramrach@centrum.cz> - 2011-05-23 18:00 -0500
              Keep your options open Mike Stephens <rubfor@recitel.net> - 2011-05-24 12:45 -0500
                Re: Keep your options open Johnny Morrice <spoon@killersmurf.com> - 2011-05-24 13:22 -0500
                Re: Keep your options open Stu <stu@rubyprogrammer.net> - 2011-05-24 16:55 -0500
            Re: Matz never said Microsoft was the Devil Incarnate. (or did he?) Christopher Dicely <cmdicely@gmail.com> - 2011-05-23 20:53 -0500
        Re: Matz never said Microsoft was the Devil Incarnate. (or did he?) Colin Bartlett <colinb2r@googlemail.com> - 2011-05-25 10:27 -0500
          Re: Matz never said Microsoft was the Devil Incarnate. (or did he?) Mike Stephens <rubfor@recitel.net> - 2011-05-25 11:54 -0500
          Re: Matz never said Microsoft was the Devil Incarnate. (or did he?) Will James <ampclj9@hotmail.com> - 2011-05-25 13:53 -0500
            Re: Matz never said Microsoft was the Devil Incarnate. (or did he?) Will James <ampclj9@hotmail.com> - 2011-05-26 12:46 -0500

csiph-web