Copy OPC UA Tag Path to Excel

I just established OPC UA connection with my CompactLogix PLC.
I’d like to copy a tag path to excel to show its value in excel cell and update the PLC as I update the cell.
Where can I find the tag link (path)?

tnx

I wasn’t aware Excel was an OPC-UA client. That is what you need to have a live connection as described.

Edit: it isn’t, but there are third-party addons, like this:

https://opcexpert.com/opc-to-excel/

I am familier with OPC Expert but I do not know how link the OPC expert to Ignition 8 ?!

See the “Connecting with UA Discovery” section of this page in the manual:

https://docs.inductiveautomation.com/display/DOC80/OPC+UA+Server+Settings

1 Like

If a connection was establish between Ignition and OPC-UA Client, just open the OPC browser in the designer, find the tag you want and drag and drop the tag folder provider. Then, edit the tag and in the property “OPC tag path”, you may read the path. If your connection is not Client OPC-UA type you may want to read the documentation for CompactLogix mapping and manually create the OPC path or use the OPC UA module and perform addressing and try my first advice.

This part of Excel is the one I’m not sure how to do it. You may need to create a tag script event to read the path in a Excel file and update it if it changes.

1 Like

I successfully established OPC UA connection in Ignition and it says it is connected.
but I do not know how to read/write tags in Excel?

I successfully established OPC UA connection in Ignition and it says it is connected.
but I do not know how to read/write tags in Excel?

If I understood. You want to update a Excel cell value and via OPC UA Ignition Module and update it to the PLC value?
If so, why or how the OPC path is related if you successfully established a connection?

I think the best practice for testing is to create 2 tag per wanted value. One tag that reads the OPC and the other to be independent memory tag that directly read a value from Excel then you create a script to write from the memory to the OPC tag.
As I said, first try to create a memory tag that can read a value from excel probably by scripting and then solve the rest

Don’t know. I don’t trust Excel for any direct process connections. (I avoid it like the plague, actually.) You’ll have to dig through the documentation for whichever plug-in you chose to be the OPC client inside Excel. If it doesn’t provide browsing of the connected server, you’ll probably want to look up the OPC node addresses on the Ignition side (using the OPC Browser in the Ignition Designer).

I just established a connection inside the Ignition and can r/w PLC tags from Ignition. But I could not set up a connection with Excel to see tags’ values in Excel.
My question is, how can I connect Ignition OPC UA to Excel?

You don’t. You connect Excel to Ignition OPC UA via a plug-in. Note, Excel is the client.

1 Like

You are right. What do you mean of plug-in? is it a specific software or 3rd party? please explain more if possible and give me a hint or plug-in name.

I linked to one possibility above. It’s website describes the kind of connection you need. You’ll have to figure out how to use it, using the Discovery URL of Ignition, and the node addresses exposed by Ignition into your Logix processor.

1 Like

Hi pturmel,
I have read both links you gave me above. I got some points but I could not figure it out how to connect Ignition OPC UA to OPC expert. As I add new server to OPC expert with that address of “opc.tcp://localhost:62541/discovery”, it says it could not connect to the address. I set all security to NONE in Ignition side. Could you help me?

Is Ignition on the same computer as OPC Expert? If not, you will have to reconfigure Ignition to listen on an exposed IP address and connect to that. You may also have to configure your network and your firewall to permit such connections.

1 Like

OK I got the problem after contacting OPC expert tech.
It was an issue with the newer version of OPC expert and they told me it is a bug in the program and they will fix it ASAP.
every thing from the Ignition side is OK.
Thank you every one for helping me.

1 Like