WinCC学习笔记.docVIP

静态文本显示日期 #include apdefap.h char* _main(char* lpszPictureName, char* lpszObjectName, char* lpszPropertyName) { time_t timer; struct tm *ptm; char *p; time(timer); ptm=localtime(timer); p=SysMalloc(9); //sprintf(p,%02d:%02d:%04d,ptm-tm_mday,ptm-tm_mon+1,ptm-tm_year-100+2000); sprintf(p,%04d年%02d月%02d日,ptm-tm_year-100+2000,ptm-tm_mon+1,ptm-tm_mday); return(p); } 静态文本显示时间 #include apdefap.h char* _main(char* lpszPictureName, char* lpszObjectName, char* lpszPropertyName) { time_t timer; struct tm *ptm; char *p; time(timer); ptm=localtime(timer); p=SysMalloc(9); sprintf(p,%02d:%02d:%02d,ptm-tm_hour,ptm-tm_min,ptm-tm_sec); return(p); } 静态文本显示星期 #include apdefap.h char* _main(char* lpszPictureName, char* lpszObjectName, char* lpszPropertyName) { time_t timer; struct tm *ptm; char *p; int week_day; time(timer); ptm=localtime(timer); p=SysMalloc(9); week_day=ptm-tm_wday; switch(week_day) //输出星期数 { case 0: sprintf(p,星期日); break; case 1: sprintf(p,星期一); break; case 2: sprintf(p,星期二); break; case 3: sprintf(p,星期三); break; case 4: sprintf(p,星期四); break; case 5: sprintf(p,星期五); break; case 6: sprintf(p,星期六); break; } return(p); ｝ 回复:关于WINCC与EXCEL的通讯请教zxl-net和各大师！ 你有无仔细看vb代码？excel连接wincc opc的路径主要是这样得到的： Const ServerName = OPCServer.WinCC－－－要连的是wincc的opc服务，而不是别的服务。 Dim WithEvents MyOPCServer As OpcServer Dim WithEvents MyOPCGroup As OPCGroup Dim MyOPCGroupColl As OPCGroups Dim MyOPCItemColl As OPCItems Dim MyOPCItems As OPCItems Dim MyOPCItem As OPCItem－－－变量声明，这些变量都被声明为opc才认得的变量类型。 Dim ClientHandles(1) As Long Dim ServerHandles() As Long Dim Values(1) As Variant Dim Errors() As Long Dim ItemIDs(1) As String Dim GroupName As String Dim NodeName As String－－－还是变量声明，这些变量都被声明为vb都能认得的变量类型。 NodeName = Range(A1).Value－－－