Tillbaka till Microsoft Excel

Anslut Knoon AI med Microsoft Excel (Microsoft) för att automatisera AI-flöden.

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

microsoftExcelUpdateCellsFromCSV

BETA

Behörigheter

Files.ReadWrite

Valfria behörigheter

Files.ReadWrite.All
Sites.ReadWrite.All

Parametrar

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

Returer

Namn	Typ	Beskrivning
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.