OLE in C#

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello
I m making a C# windows application which connects to excel to retrieve live data( stock quotes which are feeded to this excel sheet from other program via internet). The data in excel sheet is continuously changing and I want it to be reflected in my C# windows application, means i should get access to dynamic data all the time (like DDE, but it's earlier technology).

So my question is:
Can I use OLE with c# to maintain a permanent link to Excel so that data flow is there? Is OLE the right technology as speed is an important criteria for my application.?
 
Hi!

There are several options available:
1) use realt time server coming with Excel 2003
2) you can try to subscribe to events in Excel.Sheet class instance which
holds data of interest - however it will be very slow I think

Best choice will be RTK Excel server but than be careful with known issues
which affect speed of data feed when interoperating via automation (search
KB for articles on it - I could not find any links left from previous
project on my machine).

OLE is last resort as according to my experience interoperating with managed
code is tough.

Hope this helps.

Jacek



U¿ytkownik "vivek thakur said:
Hello
I m making a C# windows application which connects to excel to retrieve
Click to expand...
live data( stock quotes which are feeded to this excel sheet from other
program via internet). The data in excel sheet is continuously changing and
I want it to be reflected in my C# windows application, means i should get
access to dynamic data all the time (like DDE, but it's earlier technology).
So my question is:
Can I use OLE with c# to maintain a permanent link to Excel so that data
Click to expand...
flow is there? Is OLE the right technology as speed is an important criteria
for my application.?
 
Back
Top