Is there any limit of the number of DNA functions?

Jul 25, 2012 at 2:49 AM
Edited Jul 25, 2012 at 7:11 AM

Hi, Govert,

 

I try to wrote 1024 functions in a DLL, but  it has 74  can not be called in Excel (# NAME?)

Is there restrictions?

Regards~

================================================

<?xml version="1.0" encoding="gb2312"?><DnaLibrary Name="Excel-DNA Library in C#" RuntimeVersion="v4.0"> <ExternalLibrary Path="Excel.Functions.dll" LoadFromBytes="true" /></DnaLibrary>

Coordinator
Jul 25, 2012 at 7:22 AM

Hi,

Yes - there is a limit of 1000 functions exported from an add-in.

-Govert

Jul 25, 2012 at 7:35 AM

 

thank u kindly~

Jul 25, 2012 at 8:16 AM
govert wrote:

Hi,

Yes - there is a limit of 1000 functions exported from an add-in.

-Govert

 

Does this limitation can be removed? Or other solutions? If i want to more than 1000... 

 

Jul 25, 2012 at 9:41 AM

Hi, Govert

We have solved this problem through your source code comments. Thanks a lot ~  :)

Jul 25, 2012 at 9:51 AM

Wow, more than a 1000 functions in one addin! What are you guys doing? That’s a pretty impressive extension and I wouldn’t want to be supporting it.

It’s a shame excel doesn’t allow for overloading on functions and enums on parameters, no? It would make combining similar functions much easier.

Ian

Ian Murphy

San Agustinalde, 1 esc.dcha. 6º dcha. · 48200 · Durango · Bizkaia

ian@integra-xp.com

946 21 52 65

www.integra-xp.com

946 20 00 41


En cumplimiento de la Ley Orgánica 15/1999, de Protección de Datos de Carácter Personal, se le informa que sus datos personales, facilitados por Ud., están incluidos en un fichero con finalidad de gestionar la relación comercial que nos une, así como de informarles de los productos o servicios de nuestra empresa, por correo, fax o correo electrónico, que pudiera serle de interés, cuyo responsable es INTEGRA EXPERIENCE, S.L. - SAN AGUSTINALDE, 1 ESC.DCHA. 6º DCHA, 48200, DURANGO, BIZKAIA. Podrá ejercitar sus derechos de acceso, rectificación, cancelación u oposición remitiendo una solicitud por escrito a la dirección anteriormente citada, acompañando un documento para su identificación.

De: luoyabei [email removed]
Enviado el: miércoles, 25 de julio de 2012 11:42
Para: Ian Murphy
Asunto: Re: Is there any limit of the number of DNA functions? [exceldna:388809]

From: luoyabei

Hi, Govert

We have solved this problem through your source code comments. Thanks a lot ~ :)

Jul 26, 2012 at 7:34 AM

 

I hate to do so, but this time have to do like this.