Skip to main content

worksheet : TABLE_CLEAR

Overview​

This video demonstrates the TABLE_CLEAR worksheet command in Nitro-CELL, which removes all data rows from an existing Excel table while preserving the table structure and column headers. This is useful for resetting a table before populating it with fresh data from a new automation run. Unlike TABLE_DELETE, which removes the entire table, TABLE_CLEAR keeps the table definition intact so it can be immediately reused. The video shows how to enter the command, execute it, and verify the table was cleared while retaining its structure.

Key Steps​

  1. Identify the table to clear by name
  2. Enter the TABLE_CLEAR command with the table name
  3. Execute the command to remove all data rows from the table
  4. Verify the table structure and headers remain intact
  5. Populate the cleared table with new data using subsequent commands

Tips​

  • Use TABLE_CLEAR at the start of each automation run to ensure fresh data
  • The table structure and headers are preserved — only data rows are removed
  • Combine with TABLE_EXISTS_BOOL to check the table exists before clearing