Excel calculation engine for fast calculations

[Venkat]

Hi,

We have a requirement to manipulate and calculate a workbook behind the
scenes with better performance. Initially we used Microsoft excel to do this
but we ended up with COM related problems (performance and problems while
killing the new instance created by us).

Later we looked at Spreadsheetgear which has most of the excel common
functionality. The problem with this one is, it has limited support for
financial functions and complex funtions. It does not execute/results
complex formulas and resulting wrong values in our calculations.

We are looking for a proper calculation engine which can be used to
manipulate workbooks with greater performance. We need the following
capabilities in a tool
1) Opening and editing workbooks behind the scenes.
2) Expanding cell ranges and deleting cells
3) Ability to delete/add named ranges
4) Support for most common excel functions, math, financial and complex
formulas.
5) Support for macro execuction.
6) Displaying and reading values from excel ranges with good performance.

We liked to have lighter version of Excel (without UI), so that we can use
object model to achive our goal. Can anyone suggest a good way to achive
this. We are happy to use any third party component available in the market
to do this.

Any suggestions? Thanks in advance for any help.

Venkat

 

[mattiasw]

We are looking for a proper calculation engine which can be used to
manipulate workbooks with greater performance. We need the following
capabilities in a tool
1) Opening and editing workbooks behind the scenes.
2) Expanding cell ranges and deleting cells
3) Ability to delete/add named ranges
4) Support for most common excel functions, math, financial and complex
formulas.
5) Support for macro execuction.

What do you use macros for? If you want access to the complete Excel
object model, Excel is the only alternative.

If you only want custom made functions for calculating advanced stuff
not supported by Excel, there are solutions, for example rewrite these
to dotnet.

6) Displaying and reading values from excel ranges with good performance.

What do you mean by "displaying", displaying where? On the web?

BR,

Mattias

http://www.spreadsheetconverter.com