Is it possible to return data from a function as a formatted table rather than a dynamic array?

[Sean Tomlinson]

Hi Govert,

I have a set of tabular functions where the return type is object[,], thus data is returned as a dynamic array. I do like using dynamic arrays and they are quite powerful but some of my users prefer to work with tables (and as far as I can tell this is not an easy conversion?). I would like to introduce an option to return my data as a formatted table rather than a dynamic array. Is it possible to return a Table type in ExcelDNA?

Thanks!

[Govert van Drimmelen]

Not easily. Excel tables and dynamic arrays don't work together so we'll, and there is no support for tables from .xll add-ins.

It's a worthy request to ask Microsoft in the feedback button.

-Govert

--
You received this message because you are subscribed to the Google Groups "Excel-DNA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/exceldna/a80f2776-a210-4b38-9f2e-801d5fedd70an%40googlegroups.com.

[Sean Tomlinson]

Thanks Govert!