Excel basic 中使用打开 action

使用打开 action,以只读模式或读写模式打开 Microsoft Excel 电子表格,使用密码打开电子表格等。

过程

要打开 Microsoft Excel 电子表格,请执行以下操作:

  1. 操作面板中的 Excel 基础班 package双击或拖动打开 action
  2. 选择要从哪里打开 Microsoft Excel 电子表格:
    注: The Excel basic package supports files that are a maximum size of 30 MB.
    • Control Room 文件: 允许您从 Control Room 打开文件。
      注: 当您从 Control Room 打开一个 Excel 文件并在文件中进行更改时,更新后的文件不会保存在 Control Room 中。此 action 仅支持从桌面打开的 Excel 文件。
    • 桌面文件: 允许您从设备打开文件。 此字段还接受作为字符串变量或全局值的文件路径输入。
    • 变量: 允许您通过指定文件变量打开文件。
  3. 如果 Microsoft Excel 电子表格包含标题行,请选中工作表包含标题复选框。
  4. 选择特定工作表名称选项并指定要在 Microsoft Excel 电子表格打开时激活的工作表的名称。
  5. 选择只读模式读写模式,分别在只读或编辑模式下打开 Microsoft Excel 电子表格。
  6. 如果需要密码才能打开 Microsoft Excel 电子表格,请选中需要密码复选框。
  7. Select any of the following tabs to create an Excel session:
    • Local session: Specify a session name that can be used only in the current bot.
    • Global session: Specify a session name that can be used across multiple bots, such as parent bots, child bots, and other child bots of the parent bots .
      You can also use the Global session option to loop through each row in an Excel advanced worksheet.
      注: You can open an Excel worksheet by using the Global session option and use it across multiple bots without having to share the session by using the Set session variable action.
      You can also close the session from the child bot when you are using the Global session option and sharing the session across child bots.
      重要: If you close the session from the child bot and run the parent bot, then in the parent bot, the actions that come after the child bot are not run, and the bot fails with an error because the session has already been closed from the child bot.
    • Variable: Specify a session variable that can be used to share that session with other child bots.
    注: When you use more than one workbook to automate an operation, you must use different session names for each workbook. If you want to use the same session name to automate all the workbooks, you must first close the session of one workbook before using the same session name for another workbook.
  8. 会话名称字段中输入会话名称。
  9. 单击保存