SIMATICHMISiemensAG2003.Allrightsreserved.©SITRAINTrainingforAutomationandDrivesDate:12.02.2020File:SWINCC_09C.1使用Windows标准接口ODBCOLEOCXSQLDDEOPCActiveXSIMATICHMISiemensAG2003.Allrightsreserved.©SITRAINTrainingforAutomationandDrivesDate:12.02.2020File:SWINCC_09C.2目标-开放结构-OLE自动控制-ODBC-DDE-OCX-ActiveXSIMATICHMISiemensAG2003.Allrightsreserved.©SITRAINTrainingforAutomationandDrivesDate:12.02.2020File:SWINCC_09C.3WinCC开放结构的概貌(1)Windows(2)WinCC(3)Objects(4)SYBASEActiveX(1)*OPC(1)Connec-tivity(4)CHN(3)OLL(3)API(2)Aktion(2)OCX(1)*SQL(1)ODBC(1)*OLE(1)*DDE(1)*SIMATICHMISiemensAG2003.Allrightsreserved.©SITRAINTrainingforAutomationandDrivesDate:12.02.2020File:SWINCC_09C.4OLE自动控制(1/2)(例如通过Excel访问WinCC变量)SIMATICHMISiemensAG2003.Allrightsreserved.©SITRAINTrainingforAutomationandDrivesDate:12.02.2020File:SWINCC_09C.5OLE自动控制(2/2)(例如通过Excel访问WinCC变量)WinCC和Excel的数据交换OLE测试应用SIMATICHMISiemensAG2003.Allrightsreserved.©SITRAINTrainingforAutomationandDrivesDate:12.02.2020File:SWINCC_09C.6WinCC数据的ODBC应用演示1/3评估阀1:3x阀2:3x...WinCC数据库SIMATICHMISiemensAG2003.Allrightsreserved.©SITRAINTrainingforAutomationandDrivesDate:12.02.2020File:SWINCC_09C.7WinCC数据的ODBC应用演示2/3SIMATICHMISiemensAG2003.Allrightsreserved.©SITRAINTrainingforAutomationandDrivesDate:12.02.2020File:SWINCC_09C.8WinCC数据的ODBC应用演示3/3SIMATICHMISiemensAG2003.Allrightsreserved.©SITRAINTrainingforAutomationandDrivesDate:12.02.2020File:SWINCC_09C.9例如使用MSWordArt2.0集成WinCC中的OLE对象SIMATICHMISiemensAG2003.Allrightsreserved.©SITRAINTrainingforAutomationandDrivesDate:12.02.2020File:SWINCC_09C.10使用OCX和ActiveX,标准开放的对象1/3WinCCOCX含OCX对象的VB对象板SIMATICHMISiemensAG2003.Allrightsreserved.©SITRAINTrainingforAutomationandDrivesDate:12.02.2020File:SWINCC_09C.11使用OCX和ActiveX,标准开放的对象2/3类型OSIMATICHMISiemensAG2003.Allrightsreserved.©SITRAINTrainingforAutomationandDrivesDate:12.02.2020File:SWINCC_09C.12使用OCX和ActiveX,标准开放的对象3/3SIMATICHMISiemensAG2003.Allrightsreserved.©SITRAINTrainingforAutomationandDrivesDate:12.02.2020File:SWINCC_09C.13使用DDE的链接1/3(例如通过Excel访问WinCC变量)SIMATICHMISiemensAG2003.Allrightsreserved.©SITRAINTrainingforAutomationandDrivesDate:12.02.2020File:SWINCC_09C.14使用DDE的链接2/3(例如通过Excel访问WinCC变量)WinCCExcelDataExchangeDDETestApplicationSIMATICHMISiemensAG2003.Allrightsreserved.©SITRAINTrainingforAutomationandDrivesDate:12.02.2020File:SWINCC_09C.15使用DDE的链接3/3(例如通过Excel访问WinCC变量)SIMATICHMISiemensAG2003.Allrightsreserved.©SITRAINTrainingforAutomationandDrivesDate:12.02.2020File:SWINCC_09C.16通过COM模型使用OPC连接OPC客户机OPC服务器COM库Windows操作系统计算机A计算机A计算机BCOM库WindowsCOM库Windows网络OPC客户机OPC服务器DCOMSiemensOPCDAAutomation2.0SIMATICHMISiemensAG2003.Allrightsreserved.©SITRAINTrainingforAutomationandDrivesDate:12.02.2020File:SWINCC_09C.17在WinCC下直接访问完整MSExcel功能SIMATICHMISiemensAG2003.Allrightsreserved.©SITRAINTrainingforAutomationandDrivesDate:12.02.2020File:SWINCC_09C.18在WinCC下直接访问完整MSWORD功能