Data From Slc 500 To Excel Files

[3ICHRA]

HI

is possible to visualize data from plc AB slc500 to a excel file

thanks

[Savino]

A secondo il collegamento con una porta di communicazione che potrebbe essere Ethernet, DH+, DH-485, o RS-232-C, sviluppi una applicazione su PC, in ambiente VB o VC++, che va a leggere una determinata area dati, per esempio data file N, e salva gli enteri su le celle di un Excel spreadsheet usando dei commandi stringhe SQL.

Modificato: 3 aprile 2008 da Savino

[Savino]

According to the processor communication port at disposition, that it could be Ethernet, DH+, DH-485, or RS-232-C, you develop an application on PC, in VB or VC++ environment, that it goes to read a specific data area, for example a N Data Files, and saves the integers on the cells of an Excel spreadsheet file using the SQL string functions.

Modificato: 3 aprile 2008 da Savino

[Henon]

We recommend not using DDE if your are going to read and write a lot of data. DDE is resource intensive.

The perferable way to do this is with an OPC connection in an Excel form.

If however you insist on doing DDE the proper formulate is "=<Applicaiton Name>|<Topic>!<Item>".

<Applicaiton Name> = By default this is "Kepdde" for KepServer or "RsLinx" for Rslinx

<Topic> = The global topic is "_DDEData" (This is a example)

<Item> = When using the global topic this is the same as an OPC item name it will be "channel.device.tag"

Example : =Rslinx|Test!'N7:100'

[Savino]

Opss ! I have forgotten regarding the protocol.. The KEPWARE OPC is a very friendly way to get communication with AB devices.

Link KEPServerEX OPC Server