The following file formats are supported:
CSV #
A CSV file is a text file. The individual cells are separated by a separator. This means that, unlike XLSX files, no row, column or cell formatting is possible in a CSV file. For some data types, you can define formatting in the DataSuite.
| File Extension | Set the file extension. By default, CSV is used. The file extension does not affect the content of the file. |
| Encoding | Select the format in which the CSV is encoded. The encoding has an effect on how special characters are displayed, for example. |
| Delimiter | Set the delimiter to separate the individual cells. By default, a semicolon is used. |
| Formatting of data types | Here you can set how different data types are to be written to the CSV file. The following data types are summarized. Name PLC data types Date and time DT, DTL, LDT Date Date Time Time_Of_Day, LTime_Of_Day Time span Time, LTime Possible formatting for all date/time data types Notation Meaning dd Day MM Month yyyy yy Year (4 digits: 2024) Year (2 digits: 24) HH hh Hour (24) Hour (12) mm Minute ss Seconds fff Milliseconds \ Escape character to not evaluate certain characters „h \h“ => „4 h“ The number of characters entered influences the formatting. In addition to the formatting explicitly specified here, further formatting is possible by entering more or fewer characters. A preview is displayed on the right-hand side as you enter characters. All other characters (e.g. separators) are transferred unchanged to the result. Possible formatting for all numbers Notation Meaning 0 Decimal place or 0 # Decimal place if available . or , Delimiter To format floating point numbers, you can use either a period or a comma as the separator. If nothing is specified, the separator of the currently set language is used. The separator should always be preceded by a 0. The difference between 0 and # is that the characters specified with # are only displayed if the digit is not a 0. Example for the input 12.34. . => 12.34 , => 12,34 0.00 => 12.34 0,00 => 12,34 0.0 => 12.3 0.000 => 12.340 0.# => 12.3 0.#### => 12.34 |
XLSX and XLSM #
XLSX is the default file format of Excel with multiple spreadsheets. The XLSM file extension is an extension of XLSX with macros. You set all other formatting directly in Excel.
