Deletes a table column from a spreadsheet based on its name.
ColumnName - The name of the column that would be deleted.
TableName - The name of the table whose column would be deleted.
Worksheet - The name of the sheet whose column would be deleted.
ContinueOnError - The Boolean value to specify whether to continue executing the next activities even if there is an error thrown on this activity.
DisplayName - Renames the activity.
For this example, this is what the sample Spreadsheet contains:
- Add an Excel Sequence activity inside a Sequence.
- In the File Path field, search for and select your Spreadsheet document by, first, clicking the browse button.
- Add a Delete Column activity, and in the Worksheet field, write "Sheet1" (or the name of the sheet you would use).
- In the Column Name field, write "Name", and in the Table Name field, write "Info".
The use case should look as the following screenshot:
After execution, the column Name from the Info table should be deleted.