Geek asks and answers

Convert (heavily formula loaded) Excel spreadsheet to a handy web calculator

I need to create a webtool that accepts multiple input values ​​and generates multiple outputs based on complex arithmetic sequences in an Excel workbook. I'm thinking of hard-coding formulas in Javascript and creating a custom real-time input form, but I don't want to waste my time if there is a more efficient way to do this ... I heard about embedding real-time spreadsheets on web pages, but understand that it is only compatible with IE, which is not preferred. Anyone have any suggestions to help me get started?

+3
source share
2 answers

You will need more than javascript for this. Despite the gossip of the web guru, I have earned. You need IIS and Excel on the server. People get stuck on second demand, but you have to use what is available. SpreadSheet Gear - an alternative.

But the first question you need to ask yourself is, do you really need a web interface? I would explore creating your front-end in excel; with a cell mapping tab that displays your user interface elements in the cells of your calculator spreadsheet and the macro copies / pastes contents from one table to another.

The beauty of this setting is that you can run a batch through a calculator spreadsheet.

+2
source

Formula.js, Excel JavaScript.

0

More articles:


All Articles