J
johnlon
Is there a published roadmap for the Excel C API.
Will it be supported in Office 2010?
What about Windows 7?
Thanks
Will it be supported in Office 2010?
What about Windows 7?
Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
Charles Williams
It is supported by Office 2010 for both 32-bit and 64-bit Excel 2010 (with
corresponding Vista/Windows 7 versions)
Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com
corresponding Vista/Windows 7 versions)
Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com
J
johnlon
thanks
You mean the api's already exist and have been certified as compatible by MS?
IS this documented my MS somewhere?
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?
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?
S
Simon Murphy
There is a new SDK for 2010
the C API is still the recommended add-in technology for 2007.
If you look here you may get some ideas on issues with C# and Excel
http://www.codematic.net/Excel-development/Excel-Visual-studio/visual-studio-excel.htm
(.net UDFs have poor performance)
Cheers
Simon
Blog: www.smurfonspreadsheets.net
the C API is still the recommended add-in technology for 2007.
If you look here you may get some ideas on issues with C# and Excel
http://www.codematic.net/Excel-development/Excel-Visual-studio/visual-studio-excel.htm
(.net UDFs have poor performance)
Cheers
Simon
Blog: www.smurfonspreadsheets.net
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
.... 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
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