Hello,

I'd like to announce the first public alpha of excel_to_code: It can
convert excel spreadsheets (.xlsx, not .xls) into C or ruby. This allows
the excel spreadsheets to be run programatically, without excel,
anywhere that compiles basic dependency free C code or runs ruby. This
can be handy to allow excel to be used as the calculating engine behind
websites.

Currently it:
1. Only implements some formulae
2. Probably gets some syntax wrong
3. Produces naive code

But on the plus side it is used in production to power this website:
http://2050-calculator-tool.decc.gov.uk

Based on this excel model:
http://www.decc.gov.uk/assets/decc/11/tackling-climate-change/2050/3696-2050-calculator-with-costs.XLSX
... which contains tables, structured references, indirect formulae,
array formulae, SUMIFS formulae and the like.

To get from alpha to beta, I'd like to:
1.  increase the number of formulae it can manage
2.  make it produce less naive code (by implementing Excel's IF and
VLOOKUP and INDEX functions in a way that doesn't involve calculating
all possible answers before choosing one).

If anyone feels like helping with this, or just giving it a go then take
a look at:

* The Homepage: http://tamc.github.com/excel_to_code/
* The gem: excel_to_code
* Source: https://github.com/tamc/excel_to_code

It is MIT licensed.

Best wishes

tamc

-- 
Posted via http://www.ruby-forum.com/.