Tilbake til Microsoft Excel

Koble til Knoon AI med Microsoft Excel (Microsoft) for å automatisere AI-arbeidsflyter.

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

microsoftExcelUpdateCellsFromCSV

BETA

Tillatelser

Files.ReadWrite

Valgfrie tillatelser

Files.ReadWrite.All
Sites.ReadWrite.All

Parametere

Navn	Type	Beskrivelse	Påkrevd
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

Navn	Type	Beskrivelse
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.