It works that easy: Write Excel files with the Siemens S7
Unfortunately it is not possible to create real Excel files with a Siemens S7. In this article we will show you how you can still achieve your goal and create first-class xlsx documents with your PLC.
Create real Excel files with a S7 PLC
In this context, Siemens likes to refer to the possibility of creating “Excel-compatible” files with the help of WinCC. What is meant here are CSV files. These are a relic of the last century. They do not offer much more than a line-based storage of values. It is possible to import them into Excel, but something else is nice.
But nowadays customers expect a proper layout in the form of a real Excel file (xlsx). Sometimes they even make concrete specifications regarding logo, colors or fonts.
But don’t worry, we have found a good solution for this task.
Only real Excel files can do that
Formulas or charts are often used. Thus, it is easy to design an Excel template with a measured value representation in the form of line or bar charts. In addition, Excel offers a whole range of other features that are only possible with real Excel files.
The result could for example look like this:
Advantages of Excel files over CSV files
How to create Excel files with the S7
With our software DataSuite 3 (formerly SPSDataReader), you can easily create these and other Excel files with your Siemens S7 PLC. The program reads data blocks (DB) from your S7 and creates real Excel files from them.
You don’t need WinCC, no installed Excel program, no OPC server. Just install DataSuite on a PC with Ethernet connection, configure, done. This is how easy it is to write Excel data with an S7 controller.
Templates and More
We have already prepared the most important machine applications with Excel files for you. Choose your application from different templates:
The actual trigger process with allocation of the data areas in the Excel file was also designed to be very intuitive and clear:
Creating first-class Excel files with a Siemens S7 PLC is no longer witchcraft nowadays. With the right software, even beginners can automatically generate Excel reports of machines and plants.