Skip to main content

worksheet - TABLE_DELETE

Overview​

This video demonstrates the TABLE_DELETE worksheet command in Nitro-CELL, which completely removes an Excel table from the workbook. Unlike TABLE_CLEAR which only removes data rows, TABLE_DELETE removes the entire table definition including headers, formatting, and all data. The video shows how to enter the command, execute it, and verify the table was fully removed from the worksheet. This is useful for cleanup operations or when a table needs to be recreated with a different structure. The video also covers the difference between TABLE_DELETE and TABLE_CLEAR to help engineers choose the right command.

Key Steps​

  1. Identify the table to delete by name
  2. Enter the TABLE_DELETE command with the table name
  3. Execute the command to completely remove the table
  4. Verify the table no longer exists in the worksheet
  5. Recreate the table if needed using TABLE_CREATE

Tips​

  • Use TABLE_DELETE when you need to completely remove a table and its structure
  • Use TABLE_CLEAR instead if you only want to remove data while keeping the structure
  • Check TABLE_EXISTS_BOOL before deleting to avoid errors on missing tables