Tilbage til Microsoft Excel

Forbind Knoon AI med Microsoft Excel (Microsoft) for at automatisere AI-arbejdsgange.

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

microsoftExcelUpdateCellsFromCSV

BETA

Tilladelser

Files.ReadWrite

Valgfrie tilladelser

Files.ReadWrite.All
Sites.ReadWrite.All

Parametre

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

Retur

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.