العودة إلى Microsoft Excel
اتصل بـ Knoon AI مع Microsoft Excel (Microsoft) لأتمتة تدفقات عمل الذكاء الاصطناعي.
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. |