This article describes the RPA Excel functionality to remove a structured table from a sheet.

For a full list of available functions, please read EXCEL functions.

Description

The EXCEL Remove table function removes a structured table from a sheet. The cell data remains but the table formatting and structure is removed.

Setting it up

To use the EXCEL Remove table function, follow these instructions:

Once on a process map:

Navigate to the process where you would like to add the EXCEL Remove table function
Click on the green button's drop-down (right side of the green button labelled "Process")
On the menu that appears, click on the "+ Activity" item
From here you can select the EXCEL Remove table option
Click "Add" once you are done

Parameter	Required	Type	Default	Description
File path	Yes	Text	–	Full path to the Excel file.
Sheet	Yes	Text	–	Name of the sheet.
Table name	Yes	Text	–	Name of the table to remove.

This action does not produce any output variables.

Error	Description
File not open	The Excel file must be open.
Sheet not found	The specified sheet does not exist.
Table not found	No table with the specified name exists.

Removing a table does not delete the cell data – only the table structure and formatting are removed.
Use List tables to find table names before removing.