Microsoft Excel に戻る

Microsoft Excel (Microsoft) と Knoon AI を接続して AI ワークフローを自動化します。

Insert one or more new worksheet rows from CSV text at the requested position in Excel and shift existing rows down.
microsoftExcelInsertCellsFromCSV
ベータ
権限
  • Files.ReadWrite
オプション権限
  • Files.ReadWrite.All
  • Sites.ReadWrite.All
パラメータ
名前タイプ説明必須
workbookIdfile Select the Excel workbook to insert rows into.はい
worksheetNamemustache Name of the worksheet (tab) to insert rows into (e.g. "Sheet1").はい
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.はい
valueInputOptionstring How to treat the cell values: RAW = store exactly as given, USER_ENTERED = let Excel parse values and formulas.はい
insertPositionstring Whether to insert the CSV rows before or after the row referenced by the starting cell.はい
csvContentmustache CSV-formatted text for the rows to insert. Each line is a row; values separated by commas.はい
返品
名前タイプ説明
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.