Clear formats or data from cells in an Excel Online worksheet.
Due to third-party API limitations, this action card doesn't update workbooks that are stored in OneDrive shared libraries. Updates are limited to workbooks stored in personal OneDrive storage.
If a workbook is moved from personal OneDrive storage to a shared library, the Microsoft API may continue to return the data for the version of the file at the time when it was moved. If the file is moved back to personal storage, the Microsoft API may return data for both the original file and the updated file after it was moved back to personal OneDrive storage.
List of workbooks available in your account. Workbook is another word for your Excel files.
If you select a Workbook from the dropdown, ignore the Workbook ID field.
If you select
Option to specify a Excel Online workbook by ID.
Example of a workbook ID:
To get the ID for an Excel Online workbook, see Get a DriveItem resource.
|Worksheet||List of worksheets available in the specified workbook. A worksheet is an individual spreadsheet within a workbook, displayed as a tab in an Excel file.||Dropdown||TRUE|
Select the content that will be cleared from the cells.
The cell reference cells are used to construct a grid of cells to apply the clear action.
|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|
|Status Code||Result of the operation. The HTTP status code is returned by the connector and indicates whether the action taken by the card succeeded or failed. For example:
For a full list of possible status codes, see HTTP status codes.