Performance comparison of XLL and Excel Automation based UDF.

Add-in Express™ Support Service
That's what is more important than anything else

Performance comparison of XLL and Excel Automation based UDF.
 
Subscribe
Ashim Mishra




Posts: 25
Joined: 2016-03-01
Hi Team,

In your add-in express documentation # What Excel UDF Type to Choose? you guys have mentioned that XLL add-ins are faster in financial and mathematical calculations. Do you have any metrics to support that fact? Or how would you compare the performance of these two types of UDF? I would like to know any kind of approach to do that.

Thanks
Posted 05 Jul, 2019 07:43:58 Top
Andrei Smolin


Add-in Express team


Posts: 16436
Joined: 2006-05-11
Hello Ashim,

No metrics. If you need performance, you should switch to native C++. Check performance-related comments to an old Add-in Express review at https://smurfonspreadsheets.wordpress.com/2010/11/17/add-in-express-review/.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 05 Jul, 2019 07:53:29 Top