使用 Azure 逻辑应用管理 Excel Online 数据Manage Excel Online data with Azure Logic Apps

使用 Azure 逻辑应用Excel Online for OneDrive 连接器,可以基于 Excel Online for Business 或 Excel Online for OneDrive 中的数据创建自动化任务和工作流。With Azure Logic Apps and the Excel Online for OneDrive connector, you can create automated tasks and workflows based on your data in Excel Online for Business or OneDrive. 此连接器提供了可以帮助你处理数据以及管理电子表格的操作,例如:This connector provides actions that help you work with your data and manage spreadsheets, for example:

  • 创建新的工作表和表。Create new worksheets and tables.
  • 获取和管理工作表、表和行。Get and manage worksheets, tables, and rows.
  • 添加单个行和键列。Add single rows and key columns.

然后,你可以将来自这些操作的输出用于其他服务的操作。You can then use the outputs from these actions with actions for other services. 例如,如果你使用一个每周创建工作表的操作,则可以使用另一个操作通过 Office 365 Outlook 连接器发送确认电子邮件。For example, if you use an action that creates worksheets each week, you can use another action that sends confirmation email by using the Office 365 Outlook connector.

如果你不熟悉逻辑应用,请查看什么是 Azure 逻辑应用?If you're new to logic apps, review What is Azure Logic Apps?

备注

Excel Online for OneDrive 连接器可用于 Azure 逻辑应用,不同于适用于 PowerApps 的 Excel 连接器The Excel Online for OneDrive connectors work with Azure Logic Apps and differ from the Excel connector for PowerApps.

先决条件Prerequisites

  • Azure 订阅。An Azure subscription. 如果没有 Azure 订阅,请注册一个 Azure 试用帐户If you don't have an Azure subscription, sign up for a trial Azure account.

  • 用于你的工作帐户或个人 Microsoft 帐户的一个 Office 365 帐户An Office 365 account for your work account or personal Microsoft account

    Excel 数据可以作为逗号分隔值 (CSV) 文件存在于存储文件夹中,例如在 OneDrive 中。Your Excel data can exist as a comma-separated value (CSV) file in a storage folder, for example, in OneDrive.

  • 有关如何创建逻辑应用的基本知识Basic knowledge about how to create logic apps

  • 要在其中访问 Excel Online 数据的逻辑应用。The logic app where you want to access your Excel Online data. 此连接器仅提供操作,因此,若要启动逻辑应用,请选择单独的触发器(例如“重复”触发器)。 This connector provides only actions, so to start your logic app, select a separate trigger, for example, the Recurrence trigger.

添加 Excel 操作Add Excel action

  1. Azure 门户中,在逻辑应用设计器中打开你的逻辑应用(如果尚未打开)。In the Azure portal, open your logic app in the Logic App Designer, if not already open.

  2. 在触发器下,选择“新建步骤”。 Under the trigger, choose New step.

  3. 在搜索框中,输入“excel”作为筛选器。In the search box, enter "excel" as your filter. 在操作列表下,选择所需的操作。Under the actions list, select the action you want.

    备注

    逻辑应用设计器无法加载包含 100 列或更多列的表。The Logic App Designer can't load tables that have 100 or more columns. 如果可能,请减少所选表中的列数,以便设计器可以加载表。If possible, reduce the number of columns in the selected table so that the designer can load the table.

  4. 如果出现提示,请登录到 Office 365 帐户。If prompted, sign in to your Office 365 account.

    你的凭据授权逻辑应用创建与 Excel Online 的连接并访问你的数据。Your credentials authorize your logic app to create a connection to Excel Online and access your data.

  5. 继续为所选操作提供必要的详细信息并构建逻辑应用的工作流。Continue providing the necessary details for the selected action and building your logic app's workflow.

连接器参考Connector reference

如需技术详细信息(例如触发器、操作和限制,如连接器的 OpenAPI(以前为 Swagger)文件所述),请参阅以下连接器参考页:For technical details, such as triggers, actions, and limits, as described by the connector's OpenAPI (formerly Swagger) files, see these connector reference pages:

后续步骤Next steps