×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Microsoft Excel use with a PLC

Microsoft Excel use with a PLC

Microsoft Excel use with a PLC

(OP)
Hello,

I am working on a PLC based system for testing automotive type alternators.  I have a PC based oscilloscope which connects via live data link to an Excel spreadsheet.  I use the spread sheet for collecting and printing test results. (rpm vs current plots, setpoint voltage, etc.)
How do I get the PLC to send instructions to Excel?  Can Excel send instructions to the PLC?  I want the system to do the sequences automatically and print out the result without input from the operator, once it is initialized.

NathanUnger

RE: Microsoft Excel use with a PLC

Excel by itself can't send instructions to the PLC, you will need another piece of software to handle the communications between the two.
Depending on what type of PLC you have, and how you want to communicate with it, you should be able to find the right application.
There are a number of companies that offer OPC servers for most PLCs.
If you give us some more info on the PLC and type of communication, someone can probably help you.

RE: Microsoft Excel use with a PLC

If you are using AB plc i can show you how to do this... but Excel isnt designed to do this well and if you have a bunch of tags, even on a fast machine it will crawl

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources