MS OneDrive Business icon

MS OneDrive Business

Access MS OneDrive for Business and SharePoint

Actions16

Excel → Delete Rows

AI-generated

Summary

Delete rows from an Excel worksheet.

Inputs

  • driveType — Select User Drive, SharePoint Site Drive, or Shared Folder (Link). Defaults to User Drive.
  • sharedLinkUrl — URL of the shared folder when Drive Type is Shared Folder (Link).
  • userId — User email or ID for User Drive; leave empty to use the authenticated user.
  • siteId — SharePoint site to access when Drive Type is SharePoint Site Drive.
  • fileSelection — How to specify the Excel file: Browse, By Path, or By ID. Defaults to Browse.
  • browseFolder1 — First level folder/item when browsing (required if File Selection is Browse).
  • browseFolder2 — Second level folder/item when browsing (shown after selecting a folder in level 1).
  • browseFolder3 — Third level folder/item when browsing.
  • browseFolder4 — Fourth level folder/item when browsing.
  • browseFolder5 — Fifth level folder/item when browsing.
  • filePath — File path when File Selection is By Path (e.g., /Documents/file.xlsx).
  • fileId — File unique ID when File Selection is By ID.
  • worksheet (required) — Worksheet name or ID to operate on.
  • deleteMode — Whether to delete by Row Number or Row Range. Defaults to Row Number.
  • deleteRowNumber — Row number to delete when Delete Mode is Row Number. Use the _row_number from Read Rows output.
  • deleteRange — Range of rows to delete (e.g., '2:5') when Delete Mode is Row Range.

Output shape

array

Returns an array of deleted rows. When the worksheet has header rows, each item contains column values keyed by header names; otherwise a simple success object is returned.

Links

Discussion