问题描述:

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.

相关阅读:
Top