• {{item.name}}
SIMATIC S7-1500系列 {{item.name}}
{{item2.name}}
更多
常问问题

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

star star star star star
5.0 分
  • 使用操作
文档编号:78786898| 文档类型:常问问题| 发布时间:2023年10月24日
  • 0
  • 1030
  • 1120
此常问问题描述了在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

剩余80%未阅读,请登录后下载/查看文档

  • 评论
更多
  • 分享

    扫码分享

提示
您即将前往“全球技术资源库”。
“全球技术资源库”的用户名与本地支持中心(下载中心、技术论坛、找答案、1847工业学习平台)的用户名不通用。如果需要在全球技术资源库下载文档,您需要重新登录或注册。
确定
信息提示
很抱歉!您所访问的页面不存在,或网址发生了变化,请稍后再试。