How to Communicate with Excel from RsLinx?

There are times in which we want to acquire all our PLC’s data into a spreadsheet to get a clear view or something.

Now let’s see How we can communicate with Microsoft Excel from RsLinx to write the data to excel?

I am using RsLogix 500 here to communicate with Rslinx. You can also use RsLogix 5000 also.

Now I will create a sample program in Rslogix 500 to communicate with Excel.

I have created a Reset timer for 20 seconds. Basically, the timer runs for 20 seconds and resets itself and runs again endlessly.

The communication protocol we are gonna use here is the Dynamic Data Exchange or DDE protocol.

Training: Allen Bradley PLC

Communicate with Excel

Now let’s got to Rslinx, First of all, create a communication driver Emu-500 for running the program in an emulator.

Now go to DDE/OPC then click on the topic configuration.

A dialog box opens up as shown below.

The driver we created will be shown on the right side of the box Click on the Plc icon that is shown. The Model of the processor changes automatically to the program that we created on Rslogix 500.

After clicking on the PLC icon click new to create a topic. So when we now create a topic it will be associated with the processor we clicked that is Micrologic 1200 here.

We have created a topic Excel and press yes to update it.

Now we will go and download the program in Rslogix 500 and change the processor to run mode.

Now create a workbook in Excel and now we have to activate the DDE command through Excel.

Just Click randomly on any cell and write the formula, The syntax is as follows,

= Application Name|Topic Name!’TagName,L1,C1.

So for the application, I created here the function for activating DDE protocol Goes like this,

=RSLINX|Excel!’T4:0.ACC,L1,C1’

After Pressing enter since the program is in run mode the value of the accumulator in timer will instantly be updated here. The value changes as the timer run.

The above is our final Output. We can use this for many creative projects, Like where we have to visualize the data in real-time like that.

Comments

What is a Torbar? – Averaging Pitot Tubes

The Torbar is employed for flow measurement of liquids, gases, or steam in circular, square, or rectangular section ducts for large flow rates. The Torbar is an insertion type multi-port self-averaging primary sensor for flow measurement. Torbar TORBAR is a set of Pitot tubes mounted on a bar across the pipeline with no moving parts. An averaging Pitot tube is a technology, while TORBAR is a manufacturing brand name. There are several brands available in the market with VERABAR, ANNUBAR, etc. Averaging Pitot Tube Principle Purpose Averaging Pitot tube can be employed when the average velocity of the flow profile, rather than the velocity in a specific point in the cross-section is desired. Averaging Pitot Tubes Principle It measures the differential pressure between the static pressure tap and the tap of full pressure of a stream. Thus such magnitude of differential pressure is directly proportional to the square of the flow rate. Working The TORBAR is designed in such a way that ...

Ferrules and Cross Ferruling

Ferrules are identification labels provided for every wire terminations in an instrument, equipment, or electrical/instrumentation control panels. These tube-shaped sleeves can be inserted easily on each individual wire in a multi-core cable. In earlier days fixed digits/letters are used as ferrules, but now Instrumentation engineers/technicians prints out desired ferrules by using a ferrule printing machine. Typical Ferrule The numbers/ letters on the ferrules will be given as per the approved electrical hook up or loop diagrams. This helps technicians to easily identify a particular loop/wiring from a series of terminal blocks and to troubleshoot the desired terminal connection. Separate numbers on the ferrules distinguish the positive and negative polarities of wires, thus ensure the polarity protection of the instrument. Cross Ferruling As a wire is connected on its both ends, it is quite useful to use a cross reference method for wire identification. Unlike normal ferru...

Thermowell Insertion and Immersion Length

The thermowell is the industrial housing for temperature elements like RTD or thermocouple or temperature gauges. Thermowell is directly exposed to process fluid/media. Inside the thermowell, element/gauge is installed. Thermowell transfers the heat to the temperature element. Depending upon the element type, the fluid temperature can be known. So Thermowell protects the temperature element against harsh conditions and process fluid. It enables removal of the temperature element for replacement, repair, or testing without affecting the process system. Generally, thermowells are provided with all-temperature Elements like RTD or Thermocouple or temperature gauge. A few exceptions would be bearing RTD, skin type thermocouple, air duct thermometer, etc where thermowell is not applicable / required. When the thermowell assembly is inserted into the pipe, it is subjected to vibration. This vibration is caused by vortices to be generated alternately on either side of the thermowell. The...

TILI Automation

Search This Blog