What is the best and most efficient data type that can be used for WCF to send data to an Excel VBA client. For example, if Excel VBA (client) calls an operation contract which returns a list of numbers, what data type should the WCF operation returns? And how does Excel VBA client receive it and load it as an Excel VBA array?
-
Have you tried profiling several options? Also, are you really after a performance gain in sending a list of numbers? What are you doing and where does it take more time than you'd expect / tolerate?Janis F– Janis F2014-02-27 14:41:25 +00:00Commented Feb 27, 2014 at 14:41
-
Hi Romiox, I'm totally new to Excel VBA and don't even know what the possible options are. Could you please suggest a few?darcyy– darcyy2014-02-27 14:54:32 +00:00Commented Feb 27, 2014 at 14:54
-
I don't know if this is exactly what you are asking, but maybe this would help: stackoverflow.com/questions/15200110/…MattB– MattB2014-02-27 16:52:23 +00:00Commented Feb 27, 2014 at 16:52
Add a comment
|