4 ms·
It's not free but works very well so I thought I should mention it: spreadsheetgear does something similar except that they have their own calculation engine, s
by cm2187 10y ago
It's not free but works very well so I thought I should mention it: spreadsheetgear does something similar except that they have their own calculation engine, so you can run multiple instances, it does not rely on Excel or OpenOffice. You also go around the locking problem when two threads need to use the same spreadsheet (it just opens two instances of the calculation engine). But it doesn't support VBA or any non Excel function.
Now none of these solutions will be super fast, the overhead of doing the calc in Excel is pretty heavy. I have seen suggested here and suggested it myself that it would be useful to have a tool that reads a spreadsheet and converts the logic between selected input and output cells in code. Then the business could own the logic (in Excel) but it would run with zero overhead on a server.
That's not a trivial thing to do. Excel allows some pretty messy things and users aren't shy about using them. For instance the INDIRECT function allows you to arbitrary refer to any cell, which defeats a statically compiled dependency tree between cells.
[Edit] I think Aspose cells also works in a similar way and has its own calculation engine. Haven't tried it though.