Πίσω στο Microsoft Excel

Σύνδεση Knoon AI με Microsoft Excel (Microsoft) για αυτοματοποίηση ροών εργασίας AI.

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

microsoftExcelUpdateCellsFromCSV

ΒΕΤΑ

Άδειες

Files.ReadWrite

Προαιρετικές άδειες

Files.ReadWrite.All
Sites.ReadWrite.All

Παράμετροι

Όνομα	Τύπος	Περιγραφή	Απαραίτητο
workbookId	file	Select the Excel workbook whose cells you want to update.	Ναι
worksheetName	mustache	Name of the worksheet to update (e.g. "Sheet1").	Ναι
startCell	mustache	Top-left cell in A1 notation where the CSV block will be written (e.g. "B2").	Ναι
valueInputOption	string	How to treat the cell values: RAW = store exactly as given, USER_ENTERED = let Excel parse values and formulas.	Ναι
csvContent	mustache	CSV-formatted text for the cells to update. Each line is a row; values separated by the chosen delimiter.	Ναι

Επιστροφές

Όνομα	Τύπος	Περιγραφή
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.