Skip to main content

tbl_model : OPEN (PowerQuery)

Overview​

This video demonstrates using the tbl_model OPEN command with Power Query data in Nitro-CELL to open multiple Creo models from a dynamically populated Excel table. Instead of manually entering model names, Power Query pulls the model list from an external data source such as a CSV file, database, or another workbook. The tbl_model OPEN command then reads each row and opens the corresponding model in Creo. This combination enables fully data-driven workflows where the models to process are managed externally and refreshed automatically. The video covers setting up the Power Query, linking it to the tbl_model OPEN command, and executing the workflow.

Key Steps​

  1. Create a Power Query that retrieves model names from an external source
  2. Load the query results into an Excel table
  3. Enter the tbl_model OPEN command referencing the Power Query table
  4. Execute the command to open all models listed in the table
  5. Verify the models opened successfully in the Creo session

Tips​

  • Refresh the Power Query before execution to get the latest model list
  • Ensure model file paths are accessible from the Creo session
  • Power Query can filter and transform data before it reaches Nitro-CELL