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

PLC Program for Mixing Tank

Create a ladder diagram for controlling a batch mixing process. Implement a PLC program for mixing tank or Mixing Process using PLC Ladder Logic. PLC Program for Mixing Tank Fig : Mixing tank A tank is used to mix two liquids. The required control circuit operates as follows: A. When the START button is pressed, solenoids A and B energize. This permits the two liquids to begin ﬁlling the tank. B. When the tank is ﬁlled, the ﬂoat switch trips. This de-energizes solenoids A and B and starts the motor used to mix the liquids together. C. The motor is permitted to run for 1 minute. After 1 minute has elapsed, the motor turns off and solenoid C energizes to drain the tank. D. When the tank is empty, the ﬂoat switch de- energizes solenoid C. E. A STOP button can be used to stop the process at any point. F. If the motor becomes overloaded, the action of the entire circuit will stop. G. Once the circuit has been energized, it will continue to operate until it is manually stopped. Solution...

What is Relay? How it Works? Types, Applications, Testing

We use relays for a wide range of applications such as home automation, cars and bikes (automobiles), industrial applications, DIY Projects, test and measurement equipment, and many more. But what is Relay? How a Relay Works? What are the Applications of Relays? Let us explore more about relays in this guide. What is a Relay? A Relay is a simple electromechanical switch. While we use normal switches to close or open a circuit manually, a Relay is also a switch that connects or disconnects two circuits. But instead of a manual operation, a relay uses an electrical signal to control an electromagnet, which in turn connects or disconnects another circuit. Relays can be of different types like electromechanical, solid state. Electromechanical relays are frequently used. Let us see the internal parts of this relay before knowing about it working. Although many different types of relay were present, their working is same. Every electromechanical relay consists of an consists of an Elect...

Chlorine dioxide Analyzer Principle

Chlorine dioxide measurement Chlorine dioxide (ClO2) is an instable, non-storable, toxic gas with a characteristic scent. The molecule consists of one chlorine atom and two oxygen atoms – represented in the chemical formula ClO2. It is very reactive. To avoid the risk of spontaneous explosions of gaseous chlorine dioxide or concentrated solutions, it is generally handled in dilution with low concentrations. ClO2 is soluble in water, but tends to evaporate quickly. Typically it is prepared on site, for example from hydrochloric acid and sodium chlorite. The procedure provides solutions with approx. 2 g/l ClO2 that can be safely handled and stored for several days. Image Credits : krohne Sensor Parts : Reference electrode Applied chlorine dioxide specific potential Current needed to maintain the constant potential Counter electrode Measuring electrode The disinfection effect of ClO2 is due to the transfer of oxygen instead of chlorine, so that no chlorinated byproducts are formed. C...

TILI Automation

Search This Blog