9/22/2010 1:01 PM | |
Posts: 40 Rating: (1) |
I need to exchange data between PLC and EXCEL using OPC, and member of this forum Daniel has provided me two links... 1)http://support.automation.siemens.com/WW/view/en/23931842 2)http://support.automation.siemens.com/WW/view/en/24299099 All this is a little confusing to me, because this is first time that I meet with OPC... Is there any manual or document, where this is explained from begining?? Or maybe somebody can give me tips where to start with this please... I have an EXCEL file with "my data", and now All I need to do is to move this data to Step 7, using OPC?? Thank you, Goran. |
This contribution was helpful to1 thankful Users |
9/22/2010 2:35 PM | |
Joined: 9/27/2006 Last visit: 8/8/2024 Posts: 12273 Rating: (2680) |
Hello Goran; I did not realize you were not knowledgeable in OPC, so let's try to give you a basis. First, look at this definition, from Wikipedia: http://en.wikipedia.org/wiki/OLE_for_process_control OPC was designed to bridge Windows based software applications and process control hardware. Standard defines consistent method of accessing field data from plant floor devices. This method remains the same regardless of the type and source of data. OPC servers provide a method for many different software packages to access data from a process control device, such as a PLC or DCS. Traditionally, any time a package needed access to data from a device, a custom interface, or driver, had to be written. The purpose of OPC is to define a common interface that is written once and then reused by any business, SCADA, HMI, or custom software packages. Once an OPC server is written for a particular device, it can be reused by any application that is able to act as an OPC client. OPC servers use Microsoft’s OLE technology (also known as the Component Object Model, or COM) to communicate with clients. COM technology permits a standard for real-time information exchange between software applications and process hardware to be defined. It is important to note that OPC is a published specification. Consequently, no company "owns" OPC and anyone can develop an OPC server, whether or not they are a member of the OPC Foundation. In addition, anyone can integrate OPC products, and there is no pre-requisite for the system integrator to belong to any organization. It is therefore up to each company that requires OPC products to ensure that their products are certified and that their system integrators have the necessary training |
9/23/2010 4:46 PM | |
Posts: 5822 Rating: (412)
|
Dear Gogy, thisworks the same way. You may write data to the PLC... but to STEP7? It works just like reading... just the other direction. Best regards J_Bell |
9/23/2015 1:25 PM | |
Joined: 9/3/2014 Last visit: 3/13/2019 Posts: 4769 Rating: (123) |
New question published by bsinobras is split to a separate thread with the subject Read some values of a OPC server using Excel. Best regards |
Follow us on