חזרה אל Microsoft Excel

התחבר ל-Knoon AI עם Microsoft Excel (Microsoft) כדי לאוטומטי תהליכי עבודה של 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.