- {{item.name}}
在STEP 7 (TIA 博途)中,如何从MS Excel中导出变量到PLC数据类型?
- 0
- 1030
- 1120
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.
- 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".
- Open the TIA Portal.
- Open your project tree and add a new PLC data type.
- Assign a name for the new PLC data type, e.g. ControlVariables.
- In the "PLC data type" select the first upper line.
- Then click on the top left cell and press the key combination "CTRL+V".
Note
With this procedure, all variables are displayed correctly. - Create a new global data block.
- Assign a name, e.g. Control Variable.
- Mark the first upper line in the data block.
- Click on the top left cell and press the key combination "CTRL+V".
- 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
剩余80%未阅读,请登录后下载/查看文档
- 评论
-
分享
扫码分享
- 收藏 收藏
- 点赞 点赞
- 纠错 纠错
- 在Step 7(TIA 博途)中,如何配置诸如"GetStationInfo"等指令中的结构化数据类型(如"IF_CONF_MAC"或者"IF_CONF_V4")?
- 在 STEP 7 (TIA Portal) 中,如何对S7-1200/S7-1500 进行数据类型转换?
- 在 STEP 7 (TIA Portal) 中如何从一个数据块复制存储区和结构体数据到另一个数据块?
- 在 STEP 7 (TIA Portal) V13 SP1 中,如何从使用STEP 7 (TIA Portal) V12 SP1 或 V13组态的设备里上载项目?
- LR1xx 系列 & 测量到雷达表面
- 如何通过STEP 7 MicroWin软件调试SIWAREX MS称重模块
- 如何在 STEP 7-Micro/WIN 中组态 S7-200 扩展模块 SIWAREX MS ,可以使用哪些例子项目?
- 在 STEP 7 (TIA Portal) 中,如何将PLC程序中的数值类型变量转换到用户自定义 网站的文本框中?
- 如何在WinCC中显示S7数据类型S5TIME的变量?
- TIA 博图数据块中数据类型的定义
{{item.nickName}}