Πίσω στο Microsoft Excel
Σύνδεση Knoon AI με Microsoft Excel (Microsoft) για αυτοματοποίηση ροών εργασίας AI.
Find the first cell in an Excel worksheet that matches the given search criteria such as EQUALS, CONTAINS, STARTS_WITH, or ENDS_WITH.
microsoftExcelFindFirstCell
ΒΕΤΑ
Άδειες
Προαιρετικές άδειες
Παράμετροι
| Όνομα | Τύπος | Περιγραφή | Απαραίτητο |
|---|---|---|---|
| workbookId | file | Select the Excel workbook to search. | Ναι |
| worksheetName | mustache | Name of the worksheet (tab) to search in (e.g. "Sheet1"). | Ναι |
| range | mustache | Optional A1 range (e.g. "A1:D100") to limit the search area. If omitted, the entire worksheet is scanned. | Όχι |
| searchText | mustache | The text to search for inside the cells. | Ναι |
| matchType | string | How to compare the text: EQUALS, CONTAINS, STARTS_WITH, or ENDS_WITH. | Ναι |
| caseSensitive | boolean | Whether the match should be case-sensitive. Default is false. | Όχι |
Επιστροφές
| Όνομα | Τύπος | Περιγραφή |
|---|---|---|
| status | string | DONE. |
| found | boolean | Whether a matching cell was found. |
| cell.value | string | Matched cell value. |
| cell.sensitive.rowIndex | number | 1-based row index. |
| cell.sensitive.columnIndex | number | 1-based column index. |
| cell.sensitive.columnLetter | string | Column letter. |
| cell.sensitive.a1Notation | string | Cell location in A1 notation. |