Microsoft Excel로 돌아가기

Knoon AI를 Microsoft Excel (Microsoft)과 연결하여 AI 워크플로우를 자동화하세요.

Insert a new row or update an existing row in an Excel worksheet based on a match in a specific column.

microsoftExcelUpsertRow

베타

권한

Files.ReadWrite

선택사항 권한

Files.ReadWrite.All
Sites.ReadWrite.All

매개변수

이름	유형	설명	필수
workbookId	file	Select the Excel workbook where the row should be inserted or updated.	네
worksheetName	mustache	Name of the worksheet (tab) to search and upsert the row in (e.g. "Sheet1").	네
matchColumn	mustache	Column used as the unique identifier for matching rows (e.g. "A" for the first column).	네
matchValue	mustache	Value to search for in the match column. If found, that row will be updated; if not, a new row will be inserted.	네
valueInputOption	string	How to treat the cell values: RAW = store exactly as given, USER_ENTERED = let Excel parse values and formulas.	네
values	array (mustache)	Full row values to write.	네

반환값

이름	유형	설명
status	string	INSERTED, UPDATED, or ERROR.
sensitive.workbookId	string	Workbook ID.
sensitive.worksheetName	string	Worksheet name.
sensitive.range	string	Range written.
sensitive.matched	boolean	Whether a matching row was found before writing.
sensitive.matchColumn	string	Match column used.