Doing this will allow developers to execute Excel formulas without actually having Excel installed.
After the calculations have been computed and the proper cells have been modified, the result can then be printed back to a .xlsx file and saved.
Here are some key features of "RubyFromExcel":
Supported Excel formulas:
· abs
· and
· average
· choose
· count
· counta
· find
· if
· iferror
· index
· indirect
· iserr
· left
· match
· max
· min
· na
· not
· or
· subtotal
· sum
· sumif
· sumifs
· sumproduct
Requirements:
· Ruby 1/9 or higher
Find us on Google+
