M
Matthew Wieder
We are writing an Excel "Automation Add-In' (not a COM Add-In) in C#. A few
of the functions that we are exposing as Cell formulas take a number of
optional parameters. By some limitation, optional paramteres must be of type
Object instead of the type desired. The cost of taking the object and then
converting it to the desired type is proving incredibly expensive. Just that
process can take a minute for a few thousand calls as opposed to 8 seconds
with an xll. Short of reverting to an xll, is there some way to speed this
up?
of the functions that we are exposing as Cell formulas take a number of
optional parameters. By some limitation, optional paramteres must be of type
Object instead of the type desired. The cost of taking the object and then
converting it to the desired type is proving incredibly expensive. Just that
process can take a minute for a few thousand calls as opposed to 8 seconds
with an xll. Short of reverting to an xll, is there some way to speed this
up?