This repository provides a minimal, config-driven workflow for converting CREO .grt data files to Excel and generating interactive, publication-quality plots from Excel using Python and Plotly.
- Convert CREO
.grtfiles to Excel (.xlsx) for easy data inspection and further analysis. - Plot data from Excel with flexible, YAML-configurable options (columns, row ranges, plot style, output format, etc.).
- Interactive Plotly HTML: Choose X and Y columns dynamically in the browser, or overlay all Y series, if enabled in config.
- No code changes required for most workflows—just edit the
config.yaml.
-
Install dependencies (ideally in a virtual environment):
pip install -r requirements.txt
-
Convert a
.grtfile to Excel:python creo_GRT_to_excel.py
- By default, this will convert the
.grtto an Excel file in the current directory. - You can modify the script or call
grt_to_excel(input_path, output_dir)for other files.
- By default, this will convert the
-
Configure your plot in
config.yaml:- Set the path to your Excel file, columns to plot, filters, and plot style.
- Interactive mode:
- Set both
x_col: "all"andvariables: "all"to enable dropdowns for X and Y selection in the HTML plot.
- Set both
- Row filtering:
- Use
start_row,end_rowfor absolute slicing, orkeep_fractionfor fractional selection (window, first, last, middle).
- Use
- Example config is provided and well-commented.
-
Generate plots from Excel:
python creo_excel_to_plots.py
- Plots will be saved to the
plots_out/directory (configurable). - Output format: interactive HTML (Plotly). Static export (PNG/PDF/SVG) requires
kaleido.
- Plots will be saved to the
creo_GRT_to_excel.py— Converts CREO.grtfiles to Excel. Run directly or import the function.creo_excel_to_plots.py— Plots data from Excel using a YAML config. Supports interactive and fixed plotting modes.config.yaml— Main configuration file for plotting (input, filters, plot style, output).requirements.txt— Python dependencies.
To enable interactive X/Y selection in the HTML plot, set in config.yaml:
input:
x_col: "all"
plot:
variables: "all"This will generate a Plotly HTML file with dropdowns for X and Y columns, or overlay all Y series.
- Python 3.8+
- See
requirements.txtfor required packages (pandas, numpy, plotly, PyYAML, etc.)