Returning multiple items from RefreshData (RTDServer) - excel

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

Returning multiple items from RefreshData (RTDServer) - excel
 
Chris Schirlinger




Posts: 4
 Joined: 2005-11-22
Is it possible to return an array of data from a RefreshData event (RTDServer called from Excel) ?

Something along the lines of a code passed from the Excel cell that returned a X by X array of data (Easily limited by the Excel user, they could just pass limits as one of the paramaters)

I tried a few things but ended up with N/A each time
Posted 05 Dec, 2005 02:49:20 Top
Sergey Grischenko


Add-in Express team


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

No, it is not possible. Excel doesn't recognize .NET arrays as a supported type. You can only convert an array to a string and then pass it to the Excel cell.
Posted 05 Dec, 2005 16:46:11 Top
Chris Schirlinger




Posts: 4
 Joined: 2005-11-22
Is this restricted to RTD Server (RefreshData function) only?

Looking at the RTD Server, I've come to realise that this is the wrong way to go about it, and creating a basic plugin with a custom function is probably better (Since our data doesn't update THAT often... the RTD server refresh function was being called every few seconds in my test)

Is it possible to create an add in function (Say "GetData" that returns an X by Y array of data) in Add-In-Express?
Posted 05 Dec, 2005 21:16:23 Top
Sergey Grischenko


Add-in Express team


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

I agree with you. The RTD server is not suitable solution for you.
Of course, you can create a function by using Add-in Express.
You just need to create a new ClassLibrary project and add a new item by using the 'COM Excel Add-in Module' wizard.
This wizard will add a new Excel Automation Module to your project.
Posted 06 Dec, 2005 12:03:02 Top