Siemens Industry Online Support
Siemens AG
Entry type: Application example Entry ID: 109770550, Entry date: 09/08/2021

Excel code generator for TIA Portal Openness

  • Entry
  • Associated product(s)
The code generator can be used to automatically generate STEP 7 V15, STEP 7 V15.1 or STEP 7 V16 projects that have been previously configured from Microsoft Excel.
The TIA Portal Openness DLLs are based on the .NET framework version 4.6.2 and are not COM-visible, which means that they cannot be used directly in COM applications such as Microsoft Excel. The Excel Code Generator closes this gap.

A large number of similar projects can be generated. This is useful, for example, for series machines with different configurations. 

An Excel file references two DLLs and thus enables the generation of a PLC program in the TIA Portal from Excel. 
On the basis of the Excel data entered, the DLL "TiaOpennessXmlSupporter" creates the TIA XML files that are necessary to generate program blocks, PLC data types, global data blocks and tag tables in the TIA Portal. 
The second DLL "TiaOpennessForExcel" comprises selected functions of the TIA Portal Openness DLLs and makes them available for use in Excel. The "TiaOpennessForExcel" DLL is responsible for accessing the TIA Portal, the project, and the global TIA corporate library, as well as importing the TIA XML files to generate the PLC program.

Scheme Functionality

  109770550_OpennessExcelSoftGenerator_DOC_V31_en.pdf (2,0 MB)
 Registrierung notwendig  109770550_OpennessExcelSwGenerator_CODE_V31.zip (18,7 MB)
SHA-256 Checksum: 45DFA2AA43451A95D9296C8076235926959EE3641E9919E099165D4C291CC4FC

You can find Informations to SHA-256 at the entry:
How do you determine the SHA-256 or SHA-512 checksum of a file?
Security information
In order to protect technical infrastructures, systems, machines and networks against cyber threats, it is necessary to implement – and continuously maintain – a holistic, state-of-the-art IT security concept. Siemens’ products and solutions constitute one element of such a concept. For more information about cyber security, please visit
Rate entry
no rating
Requests and feedback
What do you want to do?
Note: The feedback always relates to the current entry / product. Your message will be forwarded to our technical editors working in the Online Support. In a few days, you will receive a response if your feedback requires one. If we have no further questions, you will not hear from us.