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

Groups > comp.lang.ruby > #4767 > unrolled thread

Writing formulas to excel spreadsheet

Back to article view | Back to comp.lang.ruby

Contents

  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

#4767 — Writing formulas to excel spreadsheet

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/.

[toc] | [next] | [standalone]

#4769

It is not the problem of ruby. Actually, you can trim the starting " and the last " before copying the cell.

I Hope it helps


-----Mensaje original-----
De: ampclj9@hotmail.com James [mailto:ampclj9@hotmail.com] 
Enviado el: jueves, 19 de mayo de 2011 11:16 a.m.
Para: ruby-talk ML
Asunto: Writing formulas to excel spreadsheet

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/.

[toc] | [prev] | [standalone]

Back to top | Article view | comp.lang.ruby

csiph-web