Clear Range

Clears values,formats.. from a specified range.

This activity clears values, formats, borders, etc of a given range from a user-specified excel worksheet by using the Microsoft Graph Clear range 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 cleared.

• Range: String Argument Specifies the range of cells that are to be cleared. 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].

• Clear Action: Specifies the clear action that is to be performed. The available options are:

  • All

  • Formats

  • Contents

  By default, the value is set to All.