UDF parameter as List<T>

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

UDF parameter as List<T>
Is this possible with ADX? 
Tony Gravagno


Guest


I found another product that claims to allow UDF definitions like this:

public static Object MyUDF( List<MyData> Info ) {}

MyData is a class or struct that has properties like Name and City. In an Excel sheet, a range may be passed into the UDF, such that each row would be an element of the List and columns fill the properties, in this example two columns.

I'm working toward support of ranges, and return of data in blocks for array formulas. Has anyone else here done this with ADX?

I don't mind parsing for ranges and returning proper error codes but accepting Generic lists as arguments (gasp, or returning them) seems like a neat thing to be able to do.
Posted 26 Mar, 2009 02:16:35 Top
Sergey Grischenko


Add-in Express team


Posts: 7233
 Joined: 2004-07-05
Hi Tony.

The Excel Automation project of Add-in Express doesn't support such definition for its functions.
Posted 26 Mar, 2009 13:04:55 Top