Is there a simple way to get names of all defined UDFs?

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

Is there a simple way to get names of all defined UDFs?
 
Jason Rodman




Posts: 40
Joined: 2016-11-01
I have an XLL addin with over 190 UDFs in it, and I was looking for a way to get a list of all of their names, as defined in the designer which may be different than the actual function names in code. I was hoping there was a property or way to read that metadata from your components. I know I can get it with reflection, I was just hoping there was an easier way.
Posted 23 May, 2018 08:59:32 Top
Andrei Smolin


Add-in Express team


Posts: 15108
Joined: 2006-05-11
Hello Jason,

Please look in the code we published in section "My XLL Add-in doesn't show descriptions" at https://www.add-in-express.com/docs/net-excel-udf-tips.php#xll-no-descriptions.

Does this code resemble what you are looking for?

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 23 May, 2018 09:04:57 Top
Jason Rodman




Posts: 40
Joined: 2016-11-01
Exactly what I was looking for. Thanks!!
Posted 23 May, 2018 09:12:59 Top
Andrei Smolin


Add-in Express team


Posts: 15108
Joined: 2006-05-11
Great!

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 23 May, 2018 09:13:51 Top