Hi John,

As mentioned in the previous post, Evaluate function takes array as a string
with column seperated by commas and rows seperated by semicolomn. Is there
any other function like Evaluate which will take input as array and ll
display that array into excel sheet region( say 2 * 3 table)?

Thanks,
Deepak
"B Deepak" wrote in message
...
Hi John,

Thanks for ur help. Currently I am working on how to update excel
region( say excel table with 2 rows and 3 columns). And it is doable
through array. For this I have to get TCP stream and convert it into
string with each culumn seperated by comma(,) and each row is seperated by
(;).This is all about parsing. After parsing get done, this string will be
passed to the excel ****. Now the job of the excel evaluate function to
parse the string and convert it into array. And this array will then
get populated into the excel region. All the above stuff is mentioned in
the belowed link...
http://support.microsoft.com/default...b;en-us;286258.

If we consider the performance, I have to remove parsing mechanism frm my
RTDServer. I mean we have to get a TCPStream and then convert it into
array which will then submitted to Excel. Now the job of the excel is to
invoke refreshdata funcion and update the region.
Is there any standart function of excel sheet like Evaluate which will
take input as array and ll display output into the specified region of an
excel sheet?
Can u plse help in doin this stuff?

Thanks n Regards,
Deepak

"B Deepak" wrote in message
...
Hi Grp,

I have to excel sheets which has 10 cells each. and I have to develop a
RTDServer using vb.net. Now I am assigning all my cells wich the
RTDServer formula which I is to be developed. Now can anybody suggest me
will this RTDServer face performance issue due to coninuous updates for
20 cells?

Thanks,
Deepak