Skip to main content

worksheet : TABLE_EXISTS_BOOL

Overview​

This video demonstrates the TABLE_EXISTS_BOOL worksheet command in Nitro-CELL, which checks whether a named Excel table exists in the workbook. The command returns a boolean result indicating the presence or absence of the specified table. This is useful for building conditional workflows that need to verify a table exists before attempting to populate, clear, or delete it. The video shows how to enter the command, interpret the result, and use it to make decisions in the automation workflow. This validation step helps prevent errors when working with dynamically created tables.

Key Steps​

  1. Enter the TABLE_EXISTS_BOOL command with the table name to check
  2. Execute the command to determine if the table exists
  3. Read the boolean result from the output column
  4. Use the result to conditionally execute table operations
  5. Combine with TABLE_CREATE for workflows that create tables only when needed

Tips​

  • Use TABLE_EXISTS_BOOL before TABLE_DELETE to avoid errors on missing tables
  • Combine with conditional logic for robust table management workflows
  • This command checks the current workbook only