Export Process Table Parameters

Export Process Table Parameters

File: Process_Document_Scripts/Export_Process_Table_Parameters.py
Version: 1.4
Document Type: CATProcess

---

Description

Exports machining parameters from all operations in a process document to a formatted Excel file. Each Part Operation gets its own worksheet. Captures stepover, machining tolerance, depth of cut, offset on part, offset on check, and depth of cut by level for each operation.

The output sheet uses a navy header row, alternating white/light-blue row bands per operation, bold programme names, and a frozen header row to aid readability.

Tested operation types: Sweep, Pencil, Contour Driven.

---

Requirements

Requirement	Value
Python	>= 3.10
pycatia	>= 0.9.5
xlsxwriter	Required
wxPython	Not required
Open document	CATProcess

---

Usage

1. Open a CATProcess document in CATIA
2. Run the script
3. An Excel file named Process_Table.xlsx is created in the current working directory
4. The file opens automatically when complete

---

Output

An Excel file Process_Table.xlsx with one worksheet per Part Operation. Each worksheet contains:

Column	Contents
Program Name	Name of the manufacturing program
Description	Program description (blank if default)
Operation	Activity type (e.g. Sweep, PencilTrace, ContourDriven)
Tool	Tool name from the tool change
Stepover	Maximum distance parameter
MC Tolerance	Machining tolerance
Depth of Cut	Maximum depth of cut
Offset on Part	Offset on part value
Offset on Check	Offset on check value
Depth of cut by level	Depth of cut by level for Multi-Pass

---

Adding Support for New Operation Types

If you encounter a new operation type where some columns are blank, use the built-in debug mode to discover the correct parameter indices:

1. Open the script and set DEBUG_PARAMS = True near the top of the main block
2. Run the script — every parameter index and name for each operation is printed to the console
3. Find your target parameters in the output and note their indices
4. Add any missing indices to the index list [26,27,73,...]
5. Set DEBUG_PARAMS = False and run normally

Debug mode has no impact on runtime when set to False.

---

Notes

• Requires pycatia >= 0.9.5 — earlier versions have a bug that prevents this script from working
• The output file is saved to the current working directory, not the process document folder
• If Process_Table.xlsx is already open in Excel the script will fail to write — close it first