Clear Cells

Clear formats and/or data from the designated cells.

Options

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

    Input

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

    Field Definition Type Required
    Cells
    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

    Output

    Field Definition Type

    Status Code

    Result of your HTTP request. See HTTP status codes.

    Number

    Related topics

    Excel Online connector

    About the elements of Okta Workflows

    Excel Online API documentation