RubyFromExcel

RubyFromExcel reads a .xlsx file, scans for formulas, extracts all affected cells, and then feeds the data to the Ruby math compiler.

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.

Doing this will allow developers to execute Excel formulas without actually having Excel installed.

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