Logix 5000 to excel

I was told the other day that it is possible to send data from a logix 5000 to an excel spreadsheet. Where is this found? Can someone point me in the right direction i have alot of different things were this would come in handy.

search here or the web.... u can use rslinx within excel

cjd1965 said:

search here or the web.... u can use rslinx within excel

Click to expand...

I believe RSLinx Professional (not free) is required.

You can use archie's AdvancedHMI (free) as opposed to buying a licensed (such as OEM) version of RsLinx

Hello,

PeakHMI can read/write data from a Logix processor to Excel.

Outlaw10801 said:

I was told the other day that it is possible to send data from a logix 5000 to an excel spreadsheet. Where is this found? Can someone point me in the right direction i have alot of different things were this would come in handy.

Click to expand...

You can use Microsoft Excel or OpenOffice Calc to read/write tags from a ControlLogix using RsLinx (not Lite version) as a DDE server.

Just now I only remember how to read tags. First things to do is create a topic in RSLinx. A topic is like a shorcut pointing to the controller. Then you need to write a function in any cell in your spreadsheet software:

Microsoft Excel:
OpenOffice Calc:
server = rslinx
topic = the topic you created in RSLinx
id = Tag name (you need to write it inside quotation marks if you use underscore)

You can find more information reading RSLinx help.

I've been using XcelReporter from Sytech.com for more than 8 years with no problems. XcelReporter is installed as and add in for excel and work as a OPC client.
My reports are generated automatically. You have to use and OPC server for AB, rslinx professional is one of them.

Hi!

Two threads handle this issue:

http://www.plctalk.net/qanda/showthread.php?t=94437

http://www.plctalk.net/qanda/showthread.php?t=54415