×
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

S7 analogue data to MSExcel

S7 analogue data to MSExcel

S7 analogue data to MSExcel

(OP)
Dear all,
I am no expert in the field of PLC programming-but i wondered if anyone could give me a few hints on how to export "analogue data" from a 315-2DP to excel format so i can then graph it in Excel.
I have a datablock set up where the analogue values are held...but how do I then for example read the value once every 10 seconds & export  

RE: S7 analogue data to MSExcel

Broad brush overview:

1)  Your PLC has to have a useable communications protocol and interface, for instance Modbus on an ethernet port, in order for anything to get access to the PLC's data.

2)  Excel is accessible through Microsoft's antiquated DDE component, or through a more robust OPC server.  An OPC server needs a specific licensed driver for whatever comm protocol and interface your PLC is using (for example, Modbus).  I don't know if OPC servers have Profibus drivers, but they routinely have Modbus drivers.

3)  Matrikon, an OPC vendor, offers not only OPC servers which fetch the data from the PLC and serve it to an OPC client, but they offer a product called Excel Reporter which is an OPC client.

http://www.matrikonanalytics.com/products/excel-reporter.aspx

Matrikon's description of its Excel Reporter reads, "Excel Reporter is an out-of-the-box solution that is easy to set up, configure and manage - get up and running in less than 5 minutes," which is very likely true; I haven't used it.

Getting an OPC server configured through DCOM and talking to the PLC tags and getting the PLC protocol running is where the real work is, whose effort shouldn't be minimized.  It's quite a task.

4) I have no idea what Siemens' HMI software (WinCC ?) costs but you might look into it, because whatever its name is, it is sure to have an historian component which does what you're wanting to and it should be tailored for Siemens use.

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