Kembali ke Microsoft Excel

Sambungkan Knoon AI dengan Microsoft Excel (Microsoft) untuk mengotomatisasi alur kerja AI.

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

microsoftExcelUpdateCellsFromCSV

Beta

Izin

Files.ReadWrite

Izin opsional

Files.ReadWrite.All
Sites.ReadWrite.All

Parameter

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

Pengembalian

Nama	Tipe	Deskripsi
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.