Delete Range

Deletes a specified range of excel data in an given excel workbook.

This activity deletes a specific range of excel data from a given excel workbook using the Microsoft Graph Clear range (when Shift property is set to None) or Delete range (when Shift property is to Up or Left) API.

Input

• Connection Id: GraphServiceClient Variable Required Specifies the office 365 connection id.

• Sheet Name: String Argument Required Specifies the name of the sheet from which the data is to be deleted.

• Range: String Argument Specifies the range of cells that are to be deleted. Input the cell range in A1-style notation like "A1:A5".

• Workbook: Object Argument Required Specifies the DriveItem of the Excel workbook whose data are to be modified. We can also specify the output variable of the Find Files And Folders activity (which is First or Results) directly as input in this property or use the output variable of the Create Workbook activity (Workbook). If we are using the Results property of the Find Files And Folders activity then we can directly specify the element in the array. For example : Results[1].

• Shift: Specifies how the surrounding cells should respond when a user-specified cell range is deleted. The available options are:

  • None- All the surrounding cells of the specified range of cells that are deleted remain unchanged while the deleted cells appear blank.

  • Up- The cells below the specified range of cells that are deleted are moved up to populate the empty cells.

  • Left- The cells to the right of the specified range of cells that are deleted are moved left to populate the empty cells

  By default, the value is set to None.