Πίσω στο Microsoft Excel

Σύνδεση Knoon AI με Microsoft Excel (Microsoft) για αυτοματοποίηση ροών εργασίας AI.

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

microsoftExcelFindCells

ΒΕΤΑ

Άδειες

Files.ReadWrite

Προαιρετικές άδειες

Files.ReadWrite.All
Sites.ReadWrite.All

Παράμετροι

Όνομα	Τύπος	Περιγραφή	Απαραίτητο
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 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.