เชื่อมต่อ Knoon AI กับ Microsoft Excel (Microsoft) เพื่อทำงานอัตโนมัติของเวิร์กโฟลว์ AI

Aggregate values within a specific A1 range in an Excel worksheet (e.g. SUM, AVG, MIN, MAX, COUNT, ARRAY_AGG, STRING_AGG).

Append a new row in an Excel worksheet without overwriting existing rows.

Append one or more rows from CSV text in an Excel worksheet without overwriting existing rows.

Create a new Excel workbook from CSV text, optionally inside a specific OneDrive or SharePoint folder.

Create a new worksheet tab inside an existing Excel workbook.

Create a new worksheet tab inside an existing Excel workbook and populate it with CSV text.

Find all rows in an Excel worksheet where a specific column matches the given value.

Find all cells in an Excel worksheet that match the given search criteria such as EQUALS, CONTAINS, STARTS_WITH, or ENDS_WITH.

Find the first cell in an Excel worksheet that matches the given search criteria such as EQUALS, CONTAINS, STARTS_WITH, or ENDS_WITH.

Find the first row in an Excel worksheet where a specific column matches the given value.

Insert one or more new worksheet rows from CSV text at the requested position in Excel and shift existing rows down.

Insert a new worksheet row at the requested row number in Excel and shift existing rows down.

Read a specific A1 range of cells from an Excel worksheet.

Read rows from an Excel worksheet within an optional A1 range.

Read all used cells from a specific worksheet (tab) in an Excel workbook.

Update a block of cells in an Excel worksheet using CSV text, starting from a specific cell.

Insert a new row or update an existing row in an Excel worksheet based on a match in a specific column.