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)
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.