Ӧ
COMPUTER APPLICATIONS
1999 19 10 Vol.19 No.10 1999



Wizcon̬ܵĸĽ
ա
ժҪWizcon̬ĿǰӦñȽϹ㷺һSCADAı۲ΪؽпơһMicrosoft ExcelWizcon̬мɵķַʵʹϵͳеõ֤
ؼʡWizcon̬Microsoft Excelϵͳ
1Wizconı
Wizconǻ32λṹ¼񡢶̼߳Ͽ̬ˣWizconWindows 95Windows NTСĿǰWizcon̬ѱΪȽSCADAӦÿ֮һWizcon10֣ȫ緶Χ3500վװʹãû֤Ѷ14000סйWizconľܲμ1ݡ
WizconıʹûʷݽʹáWizconûҪĸݣҿ԰ûҪձܱ±ȸ͵ıWizconɵıУݿͣ
 /ʱͣڱеκβʾ/ʱ䣻
 ǰֵڱеκβʾصĵǰֵ
 /Сֵڱеκβʾصĳһʱڵ/Сֵ
 ƽֵڱеκβʾصĳһʱڵƽֵ
 ֵڱеκβʾصĳһʱڵĻֵ
 ȨƽֵڱеκβʾصĳһʱڵĶʱļȨƽֵ
 Χʱ䣺ͳƿص㴦ĳΧڵʱܺͣ
 ΧܼͳƿصĳһʱڴضΧڵĴ
 ¼No.ʱ䣩ͳƿصضֵʱĵnμ¼ʱ䣻
 ¼No.ֵͳƿصĳһʱڵĵnμ¼ֵ
 ֵͳƿصĳһʱڵһֵ
 ͣͳƿصĳһʱֵĺͣ
 nμ¼ʱ䣺ͳƿصĳһضֵĵnμ¼ʱ䣻
 ַͣʾΪַĿصֵ
ϱṩĹܣϵͳͿԴӡûҪݡǣһȱ㣺۲Ϊƣ籨ıѡСѡ񡢲ҳȵȡ
2ɵԭ
ûҪݣ㲻ûԱҪMicrosot ExcelӱûԱҪ󣬵ExcelеݵȴǼ޵ģҪйݿⷽı̣߻ȡ̣ɽûҪ
Wizconֵ֧DDEܺMicrosoft ExcelṩDDEʹö߼֮
DDEǲͬӦó֮ͨѶһЭ飬ͼʾDDEķڽܵDDEͻ˵Ժ󣬰DDEĵַݷ͸ͻˡ

ͼ1DDEͨѶʾͼ
DDEڲͬӦó֮ͨѶԽͨѶ磬˿֪ͨͻִĳ
ʵûҪݣExcelʵûҪıۡڼʱɽWizconΪDDEķˡExcelΪDDEĿͻˡڶӡûҪӡʱWizconͨDDEExcelʹӡExcelյִԼĴӡʹûоExcelĴڡ
йνɵתƵExcelıУExcelṩĳӵĹܡȽɵݴļУڸļУ֮ԶΪָļչΪ .CSVExcelͬʱļ͸ļExcelṩĳӹܽļӵļС
3ɵʵ
ļԭWizconExcelļɿɰʵ֡
1) Wizconġơ˵еӦ趨Сwizddes.exe͡Excel.exeӦówizddes.exeWizconṩҪΪWizcon̬Ӧó֮佨ӡУWizconΪͻˡӦóΪˣڴΪExcel
2) ExcelӱУVBAģʽڹзWizproClientؼWizconṩWizproClientؼSignalShut¼д룺
дȷWizcon˳ʱ˳Excel
Private sub WizproClient1SignalShut()
Application.quit
End sub
дرExcelûĽ
Private Sub WorkbookOpen()
Application.ActiveWorkbook.Saved = True
End Sub
ȷWizcon˳ExcelҲ˳
3) WizconWizcon豨ΪwizrepWizconԽӡļexc.csvexc.cvsеӵıУ豨Ϊreport.xls
4) Wizconжº꣺
LDCSV
ݣEXCEL SYSTEM open("exc.csv")
LDXLS
ݣEXCEL SYSTEM open("report.xls")
CLSݣEXCEL SYSTEM close()
PRINTݣEXCEL SYSTEM print()
REPORTݣĸ꣬˳ΪLDCSVLDXLSPRINTCLSCLS
ǰĸWizconΪDDEĺꡣһ͵ڶEXCELдļexc.csv͹report.xlsǹرEXCELеĻĹĸǴӡEXCELеĻĹWizconΪProgramĺ꣬ǽǰĸһ
5) дWizcon
Wizconԣ
if $time=9.00
then
BEGIN
report "wizrep 0 0 0 1439 exc.csv 0 0 "@flag""
if @flag=1
then
macro "report"
END
ϵͳÿ900ʱӡұĸʽȫܹû
÷м򵥡ʵõص㣬Ѿڱĳ﹩ˮ˾ϵͳмӦãȡûЧ
߼飺ա˶ʿʦоΪŴ㷨ɢ¼̬ϵͳ桢ҵ̿ơ
˶ʿڡҪܿơϵͳӦ÷о
ʿڡоΪ϶̬ϵͳĽģơŻ棬ɿϵͳ
ߵλ̫ԭͻеѧԺϵͳӦоɽ.̫ԭ030024
ο
1ݡգ. WizconҵӦ. 1998ȫĽ죩ҵϵͳӦѧļ. ҵ磬1998
ո:1999-05-16(޸ĸ)
