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