Dear Sir/Madam

i want to access the variables from the OPC server and store the data in the the excel sheet
how can i do this, please suggest,

dharamvir
[email protected]

 

You need a OPC to DDE server.
Most OPC suppliers have this in there product line.

 

hi guy:
the best and possibly fastest way to do it is using a software called XLReporter, it has a direct interface in excel to collect info and make report using excel.

william delatorre
cartagena, colombia

 

To present live updating OPC tags in MS-EXCEL you indeed could use an OPC-to-DDE server. This product is commercially available from a couple of companies. (Merz, Kepware, ICONICS,...)
However if your OPC server exposes hundreds or thousands of tags you will find that DDE is not the technology to base your design on.

You should then programmatically obtain OPC data from the OPC Server and place it in your spreadsheet. You can use VBA inside MS-EXCEL or write a little VB app that runs on its own and populates EXCEL (through ole automation) with "opc" data. To get access to the OPC Servers you could use the use "OPC automation DLL".
More details: opcfoundation.org, kepware.com, iconics.com

Regards
ICONICS EUROPE BV

Raymond van der Tas

 

Dear Dharanvir,

There is a very good product called Sentech officelink wherein you can browse and take the opc server tags,copy and paste in excel spreadsheet to get real time data.

visit http://www.sentech.co.nz/OfficeLink.htm

To store the history of data in a databaselike access or MS SQL,you can directly start the inbupirowe987Qilt sampler and send the data to database.

The report can then be created by u separately in eacel in the way u want...

Hope this helps

All the best

Jayaharan C J