Microsoft SharePoint Excel icon

Microsoft SharePoint Excel

Read and write Excel files in SharePoint (bypasses WAC token issues).

Workbook → Add Sheet

AI-generated

Summary

Create a worksheet in the selected SharePoint Excel workbook and save the updated file. The operation rejects an empty name or a name already used by a worksheet.

Inputs

  • Site (required) — Select a SharePoint site from the list or enter its ID.
  • Drive (required) — Select the document library or drive containing the workbook, or enter its ID.
  • File (required) — Select the Excel (.xlsx) workbook or enter its file ID.
  • Sheet Name (required) — Name for the new worksheet; it must be non-empty and not already exist in the workbook.

Output shape

A single item with a JSON object containing success, sheetName, sheetId, and totalSheets.

The operation adds the worksheet to the workbook and saves the file. If the name is empty or already exists, it returns an error; with Continue On Fail enabled, the node outputs an error object instead.

Links

Discussion