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.

Credentials

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

¥Refer to Microsoft credentials for guidance on setting up authentication.

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

• 表格

¥Table

• 向表格末尾添加行。

  ¥Adds rows to the end of the table

• 检索表格列列表。

  ¥Retrieve a list of table columns

• 检索表格行列表。

  ¥Retrieve a list of table rows

• 查找特定列值，然后返回匹配的行

  ¥Looks for a specific column value and then returns the matching row

• 工作簿

¥Workbook

• 向工作簿添加新工作表。

  ¥Adds a new worksheet to the workbook.

• 获取所有工作簿的数据

  ¥Get data of all workbooks

• 工作表

¥Worksheet

• 获取所有工作表

  ¥Get all worksheets

• 获取工作表内容

  ¥Get worksheet content

模板和示例

¥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.