Clear Cells

Clear formats and/or data from the designated cells.


Field Definition Type Required
Workbook List of workbooks available to the account. Workbook is another word for your Excel files. Dropdown TRUE
Worksheet List of worksheets available in the selected workbook. Worksheet is the individual spreadsheet within them, displayed as tabs in Excel files. Dropdown TRUE
Apply to

Select the content that will be cleared from the cells.

    • All: clear formats and content.
    • Formats: clear formats only.

      Contents: clear contents only.

  • Dropdown TRUE


    The cell reference cells are used to construct a grid of cells to apply the clear action.

    Field Definition Type Required
    Cell Reference Begin Value representing a cell (for example, A2) in the top left corner of the grid to be cleared String TRUE
    Cell Reference End Value representing a cell (for example, D4) in the bottom right corner of the grid to be cleared String TRUE


    Field Definition Type

    Status Code

    Result of your HTTP request. See HTTP status codes.


    Related topics

    Excel Online connector

    About the elements of Okta Workflows

    Excel Online API documentation