Connect CODESYS to Excel trough OPC UA

Engineering 🇬🇧
rrrod
2021-05-28
2021-06-02

  • rrrod - 2021-05-28

    Dear colleagues,
    Do we have any example of excel working as OPC UA client where we can raise the variables of a CODESYS 3.5.12 program for example?

    I have seen in the Schneider page that there is an example but it is with OPC DA.
    https://www.se.com/ww/en/faqs/FA277033/

    I am looking for an example of an excel file that works as an OPC client.

    I have seen that in the market programs like OPCExpert offer this functionality but they are paid.
    https://opcexpert.com/opc-to-excel/

    Do you have an example?

    Thank you very much!

    Rodrigo

     
    👍
    2
more posts ...

  • abner - 2021-06-01

    Hi rrrod,
    Time ago I uploaded a video on Youtube where I share some variables with Codesys and Excel via OPC using dOPC Explorer.
    I leave the link, maybe could help you...

    https://www.youtube.com/watch?v=S8PBNVdbZHw&t=405s

     
    👍
    1

    • rrrod - 2021-06-01

      Hi Carlos,
      Excelente ejemplo muchas gracias. He llegado hasta ka parte de dopc puedo ver ahi las variables todo correcto. En esta ocasion estoy utilizando OPCUA que ya viene integrado en un CPX-E PLC Festo cuando ingreso al Rensen Cliente OPC no se como configurar para que funcione con OPCUA. Sabes si este cliente funciona con OPCUA o solo con OPCDA. Luego de eso el video se ve bastante simple en solo copiar la variable y pegarla dentro de Excel. Muchas gracias

       

Log in to post a comment.