It works that easy: Write Excel files with the Siemens S7

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.

It's that easy:

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.

Forget about csv

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:

Excel file with chart created from machine data

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:

Selection of Excel templates in the DataSuite software

The actual trigger process with allocation of the data areas in the Excel file was also designed to be very intuitive and clear:

Trigger configuration in DataSuite software: Assigning Excel cells to S7 variables

Conclusion

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.

Download trial software

Test all functions free of charge for 30 days. You will receive a mail with download link for instant use.

Notes on data protection(Required)

Related posts

Siemens S7 Speed Test

Frequently S7 programmers ask the question “How can I determine the transfer speed between PLC and PC?” Example: If a

more »