ControlLogix <--> Excel
I'm an engineer at I/Gear, and we have a software called Data Transport Utility that can do that.
Our software, which runs as a service on a host PC, has a native driver that can connect to a ControlLogix PLC over Ethernet to pull the tags in to internal datapoints. We have an OPC connector as well, but I usually use the ControlLogix connector when possible.
Once the internal datapoints are populated, the data is available to any other connected device. Our software can also make a connection to a local or remote Excel spreadsheet and export the data out. The command to do this would typically be event-based, e.g. it would only write data to the spreadsheet on the change of some significant piece of PLC data (part number, serial number, etc.).
There is also a scripting component if you need to perform any sort of advanced logic on the data. The whole process would complete in a matter of milliseconds, depending on how may tags you need.
To set up the above process might take around twenty minutes.
If you want to try it out, you can download a free demo at
http://www.igearonline.com/downloads/default.asp
Let me know if you have any questions.
Mike Atwell
[email protected]