Add in project type

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

Add in project type
Com add in and udf 
Pierpaolo Paparo




Posts: 28
Joined: 2012-05-07
Hi,
I am new to add-in express.
All I want to do is to develop an add-In that in addition to custom ribbon controls an dtasks pane, it will expose also some custom udf. Those udf will also make use of the excel object model, such as looping through tables to find values to query .net objects.
What should I do? To my understanding reading the user guide, there are technical difficulties developing both a comm addi and and excel com automation module, while Xll functions are not reccomeded when using calls to the excel object module. What does this exactly mean?

I hope my question is clear. Many thanks

Pierpaolo
Posted 03 Jul, 2012 07:34:44 Top
nwein




Posts: 521
Joined: 2011-03-28
You can read about it here, just ignore the RTD portion of it.
Hope it helps but I'm sure Eugene or Andrei will reply as well.
Posted 03 Jul, 2012 10:16:28 Top
Eugene Astafiev


Add-in Express team


Posts: 8540
Joined: 2007-07-25
Hi Pierpaolo,

You are right; we don't recommend using the Excel Object Model in your UDFs. You can read more about this in the Using the Excel Object Model in an XLL section of the online documentation. Also please take a look at the HowTo: Create a COM add-in, XLL UDF and RTD server in one assembly article on our technical blog (the link was published above, thank Nir).
.NET, Extended MAPI, Windows Phone & RT
Posted 03 Jul, 2012 14:05:04 Top
Pierpaolo Paparo




Posts: 28
Joined: 2012-05-07
hi,
Thanks for your answer.
Would it e compliant with your recommendation of not using the excel object model to call

Module.CallWorksheetFunction 

In order to use other Xll from the one I am developing?

Please see your post below


http://www.add-in-express.com/forum/read.php?FID=5&TID=4266
Posted 04 Jul, 2012 02:05:54 Top
Eugene Astafiev


Add-in Express team


Posts: 8540
Joined: 2007-07-25
Hi Pierpaolo,

Yes, of course. You can use the Module.CallWorksheetFunction method in your UDFs.
.NET, Extended MAPI, Windows Phone & RT
Posted 04 Jul, 2012 06:26:04 Top