Excel C API roadmap

J

johnlon

Is there a published roadmap for the Excel C API.

Will it be supported in Office 2010?
What about Windows 7?

Thanks
 
J

johnlon

thanks

You mean the api's already exist and have been certified as compatible by MS?
IS this documented my MS somewhere?
 
J

johnlon

Incidentally Charles I was just looking on your site entirely by
cooincidence!?.
Is there a good place to ask for some advice on tracking down a perf issue
with a c# plugin for excel, that extends the available function in xl?
 
C

Charles Williams

Personally I would say c# UDFs have appalling performance rather than poor
.... although to be fair it is improving.

You can minimise the performance issues (but it will still be slower than
VBA and VB6) by
- optimising data transfer by assigning ranges to Object arrays rather than
processing cell-by-cell
- using one of the .Net Excel packages such as Addin Express, Managed XLL or
ExcelDNA (free) which use the XLL rather than COM Interop molasses-style
interface

Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com
 
C

Charles Williams

Well, Excel 2010 is still in Beta so its still a work in progress ...
The C API has been extended in Excel 2010 to allow for 64-bit and
asynchronous UDFs etc.

So the C API has been extended in both XL2007 and 2010: does not sound like
its going to go away any time soon.

Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top