Automation specialists are increasingly confronted with the question: “How can I write Excel files with my S7?
This is not possible by default. In this context, Siemens likes to refer to the possibility of generating “Excel-compatible” files with the help of WinCC. CSV files are meant here. These are a relic of the last century. They do not offer much more than a line-based storage of values. You can import them into Excel, but something else is nice.
Today, customers expect a neat layout in the form of a real Excel file (xlsx). Sometimes they even make concrete specifications regarding logo, colors or fonts.
Excel file with formatting, created from machine data
In addition, Excel offers a whole range of other functions that are only possible with real Excel files. Often formulas or graphs are used. It is therefore easy to design an Excel template with a measured value representation in the form of line graphs or bar graphs. The result can look like this:
Excel file with diagram, created from machine data