Clear formats and/or data from the designated cells.
Options
- Workbook (dropdown): a list of workbooks available to the account. Workbook is another word for your Excel files.
- Worksheet (dropdown): a list of worksheets available in the selected workbook. Worksheet is the individual spreadsheet within them, displayed as tabs in Excel files.
- Apply to (dropdown): select what should be cleared from the cells.
- All - clear formats and content.
- Formats - clear formats only.
- Contents - clear contents only.
Input Fields
The cell reference cells are used to construct a grid of cells to apply the clear action.
- Cells
- Cell Reference Begin (text): a value representing a cell (e.g. A2) in the top left corner of the grid to be cleared.
- Cell Reference End (text): a value representing a cell (e.g. D4) in the bottom right corner of the grid to be cleared.
Output Fields
- Response
- Status Code (number)