Hello friends. WinCC Professional is an extremely powerful SCADA software from Siemens. It is the most versatile and used software in the world. It supports exporting data to Excel (csv, txt) with many different forms.
Today I will guide you to use VB Script in WinCC Professional to export data to Excel File according to specific date and time.
In this project I will have 3 values including: Temperature, Humidity, Pressure and I have created Tags as below:
This is the script that I have written (I share the project at the end of the article, you can download and see), this code is as short as possible to ensure easy to understand but still fully functional.
Program Test Video
Link Download Sample Program
The project is written in WinCC Professional V15.1, so you need to use this correct version or V16, V17 to be able to read it (plc247.com has all Versions)
Note: After downloading, you need to Copy the Excel File to the correct folder in the program E:\Excel_Report\Demo.xlsx
Program Download Link
>>> Download WinCC Professional V15.1 Excel Report Program
>>> Download WinCC Professional V15.1 Software
Password Extract: plc247.com
======
Export Excel is one of the problems that every company needs, especially in the current IoT era. Hopefully the project will help those who are new to WinCC quickly understand it.
Thanks and Best Regards!