Entry type: Application example Entry ID: 109770550, Entry date: 09/08/2021
Excel code generator for TIA Portal Openness
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.
109770550_OpennessExcelSoftGenerator_DOC_V31_en.pdf (2,0 MB)
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?
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 visithttps://www.siemens.com/cybersecurity#Ouraspiration.
Feedback for the article with the entry ID 109770550
Personalization saves you typing! If you have already been registered, you can login directly. If you are not registered yet, you can inform and register yourself without obligation here (our service is free of charge).
Number of characters: 0 (max. 500)
Send copy of comment to sender. (login required)
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.
Requests and feedback
What do you want to do?
- You have a technical question / problem: Ask the Technical Support
- You want to discuss in our forum and exchange experiences with other users
- You want to create CAx data for one or more products
- You would like to send us feedback on this Entry
Support to the statistics
With this function the IDs found are listed according to number (format .txt).
Topic pages for this entry