Wróć do Microsoft Excel

Połącz Knoon AI z Microsoft Excel (Microsoft), aby zautomatyzować przepływy pracy AI.

Update a block of cells in an Excel worksheet using CSV text, starting from a specific cell.

microsoftExcelUpdateCellsFromCSV

BETA

Uprawnienia

Files.ReadWrite

Uprawnienia opcjonalne

Files.ReadWrite.All
Sites.ReadWrite.All

Parametry

Nazwa	Typ	Opis	Wymagane
workbookId	file	Select the Excel workbook whose cells you want to update.	Tak
worksheetName	mustache	Name of the worksheet to update (e.g. "Sheet1").	Tak
startCell	mustache	Top-left cell in A1 notation where the CSV block will be written (e.g. "B2").	Tak
valueInputOption	string	How to treat the cell values: RAW = store exactly as given, USER_ENTERED = let Excel parse values and formulas.	Tak
csvContent	mustache	CSV-formatted text for the cells to update. Each line is a row; values separated by the chosen delimiter.	Tak

Zwroty

Nazwa	Typ	Opis
status	string	UPDATED or ERROR.
sensitive.workbookId	string	Workbook ID.
sensitive.worksheetName	string	Worksheet name.
sensitive.range	string	Range updated.
sensitive.valueInputOption	string	Value input option used.