Knoon AI'yi Microsoft Excel (Microsoft) ile bağlayarak AI iş akışlarını otomatikleştirin.

Find all rows in an Excel worksheet where a specific column matches the given value.

microsoftExcelFindRows

BETA

İzinler

İsteğe bağlı izinler

Parametreler

İsim	Tür	Açıklama	Gerekli
workbookId	file	Select the Excel workbook to search for matching rows.	Evet
worksheetName	mustache	Name of the worksheet (tab) to search in (e.g. "Sheet1").	Evet
matchColumn	mustache	Column to search in for matches (e.g. "A" for the first column).	Evet
matchValue	mustache	Value to search for in the match column. All rows containing this value will be returned.	Evet

İadeler

İsim	Tür	Açıklama
status	string	DONE.
rows.row	array	Row values represented as an array of cell values (e.g. ["123", "John"]).
rows.sensitive.rowIndex	number	1-based index of the matched row.