在STEP 7 (TIA 博途)中，如何从MS Excel中导出变量到PLC数据类型?

STEP 7 (TIA Portal) gives you the option of importing variables from Microsoft Excel into your PLC data type.

Description
In this video we show you how to import variables from Microsoft Excel into a PLC data type and into a data block in TIA Portal.

Instructions
Prepare your data in Microsoft Excel as shown in this example. To then import your variables to STEP 7 (TIA Portal), proceed as follows.

1. In Excel you mark all the cells that include your variables and save the data in the buffer memory using the key combination "CTRL+C".
2. Open the TIA Portal.
3. Open your project tree and add a new PLC data type.
4. Assign a name for the new PLC data type, e.g. ControlVariables.
5. In the "PLC data type" select the first upper line.
6. Then click on the top left cell and press the key combination "CTRL+V".
   Note
   With this procedure, all variables are displayed correctly.
   
   
7. Create a new global data block.
8. Assign a name, e.g. Control Variable.
9. Mark the first upper line in the data block.
10. Click on the top left cell and press the key combination "CTRL+V".
11. Save and compile your project.

The procedure shown also works analogously for copying into variable tables. The reverse procedure, copying from the TIA Portal and pasting into Excel, also works without any problems.

FAQ changes since last release

The post has been revised and the video added.

Additional Keywords
UDT (User-Defined Data Type)

您可以前往全球资源库查看此文档： http://support.automation.siemens.com/CN/view/zh/78786898