Fetching real time data from excel
- by Umesh Sharma
I am seriouly looking for your valuable help first time here. If possible, plese help me.
I am developing a VB.NET app in which i read "real time data" from a excel sheet
using "Microsoft.Office.Interop.Excel" i.e. excel automation.
All cells in excel sheet are fetching stock data from some LOCAL DDE Server
like "=XYZ|Bid!GOLD", "=XYZ|Bid!SILVER", "=XYZ|Ask!SILVER" and so on...
Some cells also having fixed values like "Symbol", "Bid Rate", "32.90" etc.
Values of DDE mapped cells (i.e. =XYZ|xxxx!yyy) are continuously changing.
THE PROBLEM is here..."FIXED values" from excel cells are coming quite ok to my app
but all DDE mapped cells values are coming "-2146826246" (When datasource local dde server ON) or "-2146826265" (OFF).
Although, if i use C#.NET, it's all ok but not with Vb.NET.
I want to display range of excel (A1 to J50) into VB.NET ListView which are changing
in every 200ms (5 times in every 1 second)
================ Important ======================================================
Is it possible to BIND "listview items/columns values" with "excel cells" or some local memory variables ??
Currently, i am reading excel "cell by cell" and trying to put values in .NET listview but CPU USES are very high
as well as it's toooo slow process.
If yes, then how please ?
I am a VFP developer but new to .NET
It's very easy in VFP then why not in .NET ??
Please guide me, if someone has the solution...