Delete table column action

The Delete table column action in the Excel advanced package enables you to delete a column in a table.

Settings

  • Specify the Table name from which you want to delete a column.
    Note: The table name is a string value. It is NOT a data table name. For information on how to retrieve the Excel table name, see Rename an Excel table.
  • Select the Name or Position to specify the name or position of the column to delete.
  • Enter the name of the session used to open the workbook with the Open action.
Consider an example where you have an Excel workbook that contains a table called SalesData. You want to delete the column Region from this table.
  1. Use the Open action from the Excel advanced package.
  2. Click File > Desktop file to open the Excel workbook that contains the SalesData table.
  3. Use the Local session option to assign the session name as ExcelSession1.
  4. Use the Delete table column action, and enter SalesData in the Table name field.
  5. In the Name field, enter Region.
  6. In the Session name field, enter ExcelSession1.
  7. Click Save.

    When you run the automation, the Region column from the SalesData table is deleted.