intouch脚本资料.pdf

《intouch脚本资料.pdf》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、WonderwareApplicationServerScriptingImplementationsPart2:ReadandWriteExcelDataTechNote1043WonderwareApplicationServerScriptingImplementationsPart2:ReadandWriteExcelDataAllTechNotes,TechAlertsandKBCDdocumentsandsoftwareareprovided"asis"withoutwarrantyofanykind.SeetheTermsofUsefo

2、rmoreinformation.Topic#:#002882Created:May2014IntroductionGenerallypeopleuseadatabasesuchasSQLServer,OracleorAccesstostoredata.However,Excelcanalsoactasadatabase.UsingExcel'srichfiletypesandfunctionality,youcanenhanceyourApplicationServerapplication.ThisTechNoteintroducestheapp

3、roachofreadingandwritingExceldatafromtheIDEviaa.NETcontrol.Itcontainsthefollowingsections:ReadandwritetheExceldatausinganApplicationServerScriptExplaintheSQLtechniquesforExceldataprocessinginthe.NETControlApplicationVersionsWonderwareApplicationServer2012R2andlaterInTouch2012R2

4、andlaterReadandWritetheExcelDataUsinganApplicationServerScriptThissectionexplainsreadingandwritingExceldatafromApplicationServerusingacustomscriptfunctionlibrary.1.DownloadtheExcelOperations.zipfiletoyourGRnodeandextractthecontentstoalocaldirectory.Inthisexample,weuseC:TEMPEx

5、cel.2.CreateanewGalaxycalledGalaxyExcelandopenitintheIDE.3.ImporttheExcelOperations.dllfileandconfirmtheimportsucceeds(Figures1,2and3below).file:///C

6、/inetpub/wwwroot/t002882/t002882.htm[5/27/20148:47:41AM]WonderwareApplicationServerScriptingImplementationsPart2:ReadandWriteExc

7、elDataFIGURE1:SELECTGALAXY>IMPORT>SCRIPTFUNCTIONLIBRARYOPTIONfile:///C

8、/inetpub/wwwroot/t002882/t002882.htm[5/27/20148:47:41AM]WonderwareApplicationServerScriptingImplementationsPart2:ReadandWriteExcelDataFIGURE2:BROWSEANDSELECTTHEDLLFIGURE3:VERIFYIMPORTSUCCEEDED4.ImportExcelUD

9、A.aaPKGand$READnWRITE2Excel.aaPKGintotheGalaxy(Figures4,5,6and7below).file:///C

10、/inetpub/wwwroot/t002882/t002882.htm[5/27/20148:47:41AM]WonderwareApplicationServerScriptingImplementationsPart2:ReadandWriteExcelDataFIGURE4:SELECTGALAXY>IMPORT>OBJECT(S)OPTIONfile:///C

11、/inetpub/ww

12、wroot/t002882/t002882.htm[5/27/20148:47:41AM]Wonderwar