How to read values from ControlLogix L61 directly in Excel

 

what you need

  • AdvancedHmi Driver
  • Rockwell (Allen-Bradley) PLC (I use L61) with EthernetIP Modul
  • excel (I use office 2010)

You can download a excel file with other needed files ready to use, EthernetIP_Excel_Communication.zip

 

this method is simple and free to use, it is compatible with other Rockwell Allen Bradley PLC’s such as ControlLogix L61, or CompactLogix L32-ER,L35.

20 comments on “How to read values from ControlLogix L61 directly in Excel

  • “ActiveX component can’t create object” error message when I using this lib
    “EipCommClient.setPlcIPAddress (ipaddr)”

  • Hello,
    This works great for most of what I am looking to do. I need to read/write a lot of strings from multiple processors and this had no problems in executing the reads. The great part is that it works without having to buy an expensive OEM license. Is it possible to perform a ‘write’ function as well? I see where the data is passed to perform the ‘read’ and assume there is a similar command for a ‘write’
    EipCommClient.setPlcIPAddress
    EipCommClient.setPlcSlot
    EipCommClient.GetData
    EipCommClient.Close

    Is there a “EipCommClient.SetData” or something to that effect? Do you have a description of these?

    On a side note, I noticed that I can read Temp_DINT.1 without issue but I get an error for the same DINT if trying to read Temp_DINT.0

    Thanks for the awesome solution!

    • in this version of library is no possibility to write data, so it means, that I have to program it, but currently I dont have time to do this.

      • Do you foresee a time in the future you would be interested in doing this? I would gladly contribute financially.

  • Also, I am not in a situation where I can test at the moment, but is there a different syntax for accessing program level tags vs controller level tags?

    • Yes, there is some difference, if you need to access ProgramTags, you must set the Path, it loocks like [ProgramName]Tagname.

  • Hi, I am experiencing same issue as liu, above. Using Excel 2010 64-bit on Windows 7 64-bit, and get Error 429, “ActiveX component cannot create object.”

    Any suggestions?

  • It does not read value of string tags in Excel. Only reads the length of the string tags.

    Can you lease advise how can read string tags. Thanks

  • Hi,
    Your work was really good !
    I create a program in C# and want to add Ethernet/IP for Rockwell. How did you develop your communication protocol ?

  • How do I change the “read data” command button to call for the data from the PLC when a cycle completes? Thank you, this helped out a lot.

  • Hello, excellent driver.
    How can I test for good communication, so I can have a good read and if the communication fails, create an alarm or do a retry using an excel macro.
    Any advice would be appreciate.
    Thanks

  • This tool Works great, But i am having a problem with 1 IP Address. whenever I try to get tag values from 10.10.9.67 the macro stops with the message “Index was outside the bounds of the array” Is there something I’m doing wrong here?

  • I found that you can only use this tool for 11 different IP Addresses before you need to close it and restart it. Otherwise when you try a 12 address it will stop the macro with “Index was outside the bounds of the array”.
    Is there a way to clear temp memory in VBA to allow you to scan more IP addresses without having to close the project and reopen?

Leave a Reply

Your email address will not be published. Required fields are marked *