auto refresh excel from data push

[rchiu5hk]

Dear all,

I am writing the socket programming.
The server part has been done in c sharp vs2005. The server will push some
data to the client every second.
How can the excel be done so that excel can show the information from server
and refresh every second??

I plan to use c sharp dll function. But how can make the excel refresh every
seconds by dll which has information alert to excel to show???

[vcdebugger]

you mean to say excel will be on the client side.
You can do one thing , create a timer at the client side and try to call the DLL function in that timer which inturn will call the excel application and updates the data on the work sheet in the excel file..

[rchiu5hk]

I have think of a method.

Socket programming + Excel class programming in C Sharp DLL.

In Dll, There is client and server programming. When data push from server, client will listen to it.
When get data, update in the excel by using excel.applicationclass() to manipulate the cells in the workbook.open().

But I am afraid about the error handling which will become very complicated.