RTD returning arrays
 

Steve,

you definitely cannot return an array directly, but you can use an "array
handle" (e.g. the topic ID) and a worksheet function to "explode" the
handle.

Jens.

--
http://ManagedXLL.net/
Replace MSDN with my first name when replying to my email address!



wrote in message
ups.com...
I'd like RTD to return an array of values from RefreshData(). This
article states that this CANNOT be done directly:
http://support.microsoft.com/kb/q286258/

Instead they recommend returning the array as a string with this format
{1, 2, 3, 4; 10, 20, 30, 40; 100, 200, 300, 400}, where columns are
delimited by commas and rows by semicolons.

The string formatted version of the array can then be passed to
Evaluate() which will parse the string and populate the cells.

However there is a limitation that restricts the string length passed
to Evaluate to 256 chars
(http://www.decisionmodels.com/calcsecretsh.htm). This seems pretty
severe as it keeps the array size uselessly small.

Is there a better way to return an array from RTD and have it displayed
in the spreadsheet?