By the end of this course, you will be able to build HMI applications using TIA specific tools and TIA best practices. I am here to help you learn the basic concepts, tools, and functions that you will need to build modern, fully functional, and intuitive SIMATIC WinCC applications within the widely popular totally integrated automation solution - Siemens TIA Portal. Hi there! My name is Hans and I'm a full-time controls & automation engineer. Keep in mind to close the excel window whenever new data is added, otherwise, the script won’t work and result in an error.Are you excited about building HMI applications in TIA Portal but you're not really sure where to start? After finishing this course, you can confidently add "TIA Portal - HMI Application Builder" to your CV & start getting paid for your new skills. Now you can check the new data is inserted into the excel file.
Now close the Excel file and Start WinCC Runtime in Simulation mode.Įnter any values in the IO- Field and after that press the “Insert New Data” Button. Whenever I press the button new data is inserted into the excel report.Ĭonfigure the Alarm window with the following setting, it will be helpful to find any error in the script and troubleshoot it, if the code does not work as expected. Change this if you change the Excel file format.Ĭhange these tags if you want to add new tags and do not change any other part of the code if you don’t have any clear idea.Ĭonfigure the SCADA Screen with the following items as shown in the image.įor sample reporting, I have configured this button to trigger the excel data. Tag named excel row is for use of VB Script counting.Īdd a new VB Script and copy the code from this article.Įxcel file Starting cell number of every tag. Here we have added three tags as an example Flow, Pressure, Temperature. Export Data from WinCC Runtime Advanced into Excel Many a Times when you want to develop sophisticated and perfect SCADA with many features then to enable that features you have to use scripting language.Why do we need to use any scripting language in SCADA? It is very commonly found scripting language in various SCADA System such as Siemens, Schneider, Indusoft, AVEVA etc.VB Script is programming language developed by Microsoft.This article will focus on the usage of VB Script to log data into an excel file. These data can be of any type such as Batch Data, Alarms log, Process Data, Utility Data, etc. Data reporting is a very crucial process in Industrial Automation.
0 kommentar(er)
