Skip to content

Microsoft Excel 365 节点(Microsoft Excel 365 node)#

使用 Microsoft Excel 节点可以自动化 Microsoft Excel 中的工作，并将 Microsoft Excel 与其他应用集成。n8n 内置支持多种 Microsoft Excel 功能，包括添加和检索表格数据列表、工作簿以及获取工作表。

🌐 Use the Microsoft Excel node to automate work in Microsoft Excel, and integrate Microsoft Excel with other applications. n8n has built-in support for a wide range of Microsoft Excel features, including adding and retrieving lists of table data, and workbooks, as well as getting worksheets.

本页列出了 Microsoft Excel 节点支持的操作列表以及更多资源的链接。

🌐 On this page, you'll find a list of operations the Microsoft Excel node supports and links to more resources.

凭证

请参阅 Microsoft 凭据 了解有关设置身份验证的指南。

政府云支持

如果你正在使用政府云租户（美国政府、美国国防部或中国），请确保在 Microsoft 凭据配置中选择适当的 Microsoft Graph API 基础 URL。

This node can be used as an AI tool

This node can be used to enhance the capabilities of an AI agent. When used in this way, many parameters can be set automatically, or with information directed by AI - find out more in the AI tool parameters documentation.

操作(Operations)#

  • 表格
    • 向表格末尾添加行。
    • 检索表格列列表。
    • 检索表格行列表。
    • 查找特定列值，然后返回匹配的行
  • 工作簿
    • 向工作簿添加新工作表。
    • 获取所有工作簿的数据
  • 工作表
    • 获取所有工作表
    • 获取工作表内容

模板和示例(Templates and examples)#

Template widget placeholder.

What to do if your operation isn't supported#

If this node doesn't support the operation you want to do, you can use the HTTP Request node to call the service's API.

You can use the credential you created for this service in the HTTP Request node:

  1. In the HTTP Request node, select Authentication > Predefined Credential Type.
  2. Select the service you want to connect to.
  3. Select your credential.

Refer to Custom API operations for more information.