Geek Answers Handbook

Show value of formula with gemstone table in Rails

I am trying to show an Excel spreadsheet in a RoR application. I started using the Spreadsheet gem, which works great. However, when I do not know how to show a cell that has a formula (I want to show the resulting value). There is a Spreadsheet :: Formula class that has a value method that seems to be for this, but I don't know how to instantiate or use this class. Any help would be appreciated.

+4
source share
1 answer

Stupid to me. Just use the value method in the cell :-)

sheet = book.worksheet 0 sheet[1,2].value
+4
source

More articles:


All Articles