Description

Deletes a table column from a spreadsheet based on its name.



Attributes

Input

  • 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.

Common

  • ContinueOnError - The Boolean value to specify whether to continue executing the next activities even if there is an error thrown on this activity.

Misc

  • DisplayName - Renames the activity.


Example

For this example, this is what the sample Spreadsheet contains:



  1. Add an Excel Sequence activity inside a Sequence.
  2. In the File Path field, search for and select your Spreadsheet document by, first, clicking the browse button.
  3. Add a Delete Column activity, and in the Worksheet field, write "Sheet1" (or the name of the sheet you would use).
  4. 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.