Back to Microsoft Excel
Connect Knoon AI with Microsoft Excel (Microsoft) to automate AI workflows.
Find all cells in an Excel worksheet that match the given search criteria such as EQUALS, CONTAINS, STARTS_WITH, or ENDS_WITH.
microsoftExcelFindCells
BETA
Permissions
Optional permissions
Parameters
| Name | Type | Description | Required |
|---|---|---|---|
| workbookId | file | Select the Excel workbook to search. | Yes |
| worksheetName | mustache | Name of the worksheet (tab) to search in (e.g. "Sheet1"). | Yes |
| range | mustache | Optional A1 range (e.g. "A1:D100") to limit the search area. If omitted, the entire worksheet is scanned. | No |
| searchText | mustache | The text to search for inside the cells. | Yes |
| matchType | string | How to compare the text: EQUALS, CONTAINS, STARTS_WITH, or ENDS_WITH. | Yes |
| caseSensitive | boolean | Whether the match should be case-sensitive. Default is false. | No |
Returns
| Name | Type | Description |
|---|---|---|
| status | string | DONE. |
| found | boolean | Whether at least one matching cell was found. |
| count | number | Total number of matching cells found. |
| cells.value | string | The matched cell value, or empty string if none found. |
| cells.sensitive.rowIndex | number | 1-based row index of the matched cell, or null if none found. |
| cells.sensitive.columnIndex | number | 1-based column index of the matched cell, or null if none found. |
| cells.sensitive.columnLetter | string | Column in letter form (e.g. "A", "B", "AA") for the matched cell, or null if none found. |
| cells.sensitive.a1Notation | string | Cell location in A1 notation (e.g. "B2"), or empty string if none found. |