Microsoft SharePoint ExcelInstall

Summary

Clear all rows from the selected worksheet in a SharePoint Excel workbook and save the updated file. Select the SharePoint site, drive, Excel file, and sheet; each can be chosen from a list or entered by ID or name.

Inputs

• Site (required) — SharePoint site, selected from the list or entered by ID.
• Drive (required) — Document library or drive containing the Excel file, selected from the list or entered by ID.
• File (required) — Excel workbook to update, selected from the list or entered by ID.
• Sheet (required) — Worksheet to clear, selected from the list or entered by name.

Output shape

A single item with a JSON object containing success, sheet, clearedRows, and clearedColumns.

The operation removes all worksheet rows and saves the workbook. clearedRows and clearedColumns report the worksheet's row and column counts before clearing; the column count is reported even though the implementation removes rows.

Links

• n8n community nodes installation guide