Software Toolbox Technical Blog

1 min read

Video Tutorial: Easy Integration of Your OPC DA/UA Data with MS Excel

Apr 5, 2018 2:00:00 PM

With DDE (Dynamic Data Exchange) fast becoming obsolete technology (Microsoft superseded DDE with OLE years ago), OPC DA and, more recently, OPC UA data sources have become the primary go-to for process data integration.  Recently, Microsoft even disabled certain DDE functionality in MS Office applications due to security concerns and malware exploitation targeting the DDE interface.

But the usefulness of MS Excel for data analysis across many industries even today is still undeniable and the primary mechanism for MS Excel to connect to a data source is via DDE.  So what do you do if you're still using MS Excel for process data analysis and reporting via DDE?  What's the alternative?

The following short video blog demonstrates step-by-step how to easily read/write data from process data sources (OPC DA and OPC UA Servers) using MS Excel (without DDE) with the Cogent DataHub.

In this video, you will learn how to setup the Cogent DataHub to collect your OPC DA and OPC UA server data and then connect MS Excel with read/write access to your OPC data, all without using DDE.



Just to summarize, in this video, I've shown you:

  1. How to configure Cogent DataHub for connectivity to:
    1. OPC DA Servers
    2. OPC UA Servers
  2. How toverify good data/quality for OPC DA/UA Server connections.
  3. How to configure the Skkynet Vine plug-in for Excel to connect to OPC data in Cogent DataHub (either locally or remotely to MS Excel).
  4. How to define which OPC DA/UA data points are accessed in MS Excel.
  5. How to read and write to OPC DA/UA data points from MS Excel.

If you're interested in learning more about how to easily read/write OPC data with MS Excel, please contact us to request a trial of the Skkynet Vine plug-in for Excel.

 Learn more about OPC to Excel without DDE & Request a Trial

Win Worrall
Written by Win Worrall

Join Our Journey

Working in industrial automation since 1996, the Software Toolbox team has seen a lot. The level of automation system sophistication of our integrators and users has evolved, each driven by the demands of their market and clients.  Everyone's learning continues as technological change accelerates.

This blog is about sharing from these journeys.  From tips on implementing software, successes our clients have experienced, or new ideas and things to consider in your journey, we'll be sharing them here.

Subscribe to our Blog

Recent Posts

Posts by Topic

See all