Skip to main content

Automating Creo with Excel Tables

Overview​

This video introduces the concept of automating PTC Creo Parametric operations using Microsoft Excel tables through Nitro-CELL. It demonstrates how engineers can define a series of Creo commands in an Excel worksheet and execute them in sequence to automate repetitive CAD tasks. Nitro-CELL reads each row of the Excel table, interprets the command and its arguments, and sends the corresponding instructions to Creo Parametric. This approach eliminates the need for manual, click-by-click interaction with Creo for bulk operations such as opening models, setting parameters, saving files, and exporting data. The video covers the fundamental workflow of setting up an Excel workbook, entering commands, and running the automation to control Creo directly from the spreadsheet environment.

Key Steps​

  1. Open the Nitro-CELL Excel workbook and navigate to the command worksheet
  2. Enter Creo automation commands into the Excel table rows with the required arguments
  3. Connect the workbook to a running Creo Parametric session
  4. Execute the command table to run all operations sequentially in Creo
  5. Review the results and any status messages returned to the worksheet

Tips​

  • Start with simple single-command tables before building complex multi-step automations
  • Keep your Creo session open and models accessible before running the Excel commands
  • Use the status column in the worksheet to verify each command executed successfully