Author Topic: Excel Link  (Read 11197 times)

DLUN

  • Newbie
  • Posts: 18
    • View Profile
Excel Link
« on: January 26, 2010, 12:38:20 PM »
Does anyone know how I can log a history of data inported from my PLC to excel. I was thinking about creating a macro that inputs a row everytime that the top is full, but I want to know if excel link has any built in functionality that would allow me to log the information without erasing the previous entry.

support

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 3174
    • View Profile
    • Internet Programmable PLCs
Re:Excel Link
« Reply #1 on: January 26, 2010, 01:30:08 PM »
Yes, in ExcelLink you can define if you want the info to be imported to a new row every time it accesses data in the PLC. It can also be defined to overwrite old data after some amount (e.g. after 1000 data points) have been received.

If your PLC is attached to a PC by RS232 port, you can also make the PLC open a file on the PC and append data to it. There is no limit of how many lines you can append to the file. You can also create different file names (say based on date) so that you can save all the data of a particular day to a particular file.

For more details, please read "File and Email Services".
Email: support@triplc.com
Tel: 1-877-TRI-PLCS