Microsoft Excel öğesine geri dön

Knoon AI'yi Microsoft Excel (Microsoft) ile bağlayarak AI iş akışlarını otomatikleştirin.

Insert one or more new worksheet rows from CSV text at the requested position in Excel and shift existing rows down.
microsoftExcelInsertCellsFromCSV
BETA
İzinler
  • Files.ReadWrite
İsteğe bağlı izinler
  • Files.ReadWrite.All
  • Sites.ReadWrite.All
Parametreler
İsimTürAçıklamaGerekli
workbookIdfile Select the Excel workbook to insert rows into.Evet
worksheetNamemustache Name of the worksheet (tab) to insert rows into (e.g. "Sheet1").Evet
startCellmustache Starting cell in A1 notation (e.g. "B2"). The referenced row is used together with insertPosition to decide where the CSV rows are inserted, and values are written starting from this column.Evet
valueInputOptionstring How to treat the cell values: RAW = store exactly as given, USER_ENTERED = let Excel parse values and formulas.Evet
insertPositionstring Whether to insert the CSV rows before or after the row referenced by the starting cell.Evet
csvContentmustache CSV-formatted text for the rows to insert. Each line is a row; values separated by commas.Evet
İadeler
İsimTürAçıklama
statusstring INSERTED or ERROR.
sensitive.workbookIdstring Workbook ID.
sensitive.worksheetNamestring Worksheet name.
sensitive.rangestring Range where the inserted CSV values were written.
sensitive.valueInputOptionstring Value input option used.
sensitive.insertPositionstring Whether the CSV rows were inserted BEFORE or AFTER the referenced row.