I am tasked to develop a very simple web layer for a very complex algorithm that is implemented as an Excel worksheet. This script would be called from a Ruby on Rails app that would be presenting the user with the forms, check validations and whatnot, and should return just a number. After perusing this site, my best shot is to automate Excel using Python or Ruby under Windows and run the algorithm there --we are a Ruby shop, but I've found more info for Python.
I think I can write a Python script to run the calculation in a day, but now the final question remains: how do we put a web layer on top of the core script? We are familiar with Apache, so installing Python as a Apache module is my straight thought, but we could also install Twisted and try to run the web server itself in Python.
What would be your choices?