Control

PLC register data to excel spreadsheet

S

Thread Starter

Seth Yancey

I have a web server enabled HMI (e-terminals E300) connected to a Mitsubishi A2N CPU. The HMI unit is on our plant wide Ethernet network. I can create web pages to be served by the HMI that allow me to view what product code has been bar code scanned and entered into a register in the PLC memory. What I want to do is have the information in this register imported into an MSExcel spreadsheet to produce somewhat of a production report. The spreadsheet "cursor" will have to advance each time a new product code is scanned (can this be done with some kind of trigger bit). I will also want a time/date stamp associated with each entry.

Can I do this? If so, please recommend any references (web or printed) that could get me started.

Seth Yancey
 
J

Jignesh

Hello!!!

You can use LabView's Software for HMI application which will allow you to have the data (bar code) imported and with that you can use Visual Basic codes to work with spreadsheet.

Good Luck..

Jignesh

 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
C Reading Register Data from a Modbus PLC Simulator Modbus 4
S PLC Register Meaning Programmable Logic Controller - PLC 1
L PLC and 3X Register Communication General Communications Chat 3
D Cannot Read Values from Holding Register (DB10.DBW0) of PLC Programmable Logic Controller - PLC 1
R access to 16 data values stored in register of tsx 37 micro plc Programmable Logic Controller - PLC 0
Similar threads
Reading Register Data from a Modbus PLC Simulator
PLC Register Meaning
PLC and 3X Register Communication
Cannot Read Values from Holding Register (DB10.DBW0) of PLC
access to 16 data values stored in register of tsx 37 micro plc

You May Also Like

Top