Skip to main content

Step 9 of 13: Parameter Mapping Option 2: Drive a CAD Model via an Excel File

EL4.9: Linking CAD Parameters via Excel in Liftdesigner

Written by Alexandra Göttert

The steps use the rail bracket examples from the EL4 training models; you can apply them to your own CAD models in the same way.

Understand how the example model is driven. For the second rail bracket, the bracket's dimensions are controlled via an existing Excel spreadsheet within the assembly. The goal is to drive a CAD model parameter via an Excel file integrated into the Liftdesigner Run Automation function, so the original model adapts to the elevator project.

DP-SW RB00 0000 00.SLDASM

Expected result

Prerequisites

  • Your CAD model's parameters are linked to an existing Excel file.

Steps

1.) Add a new automation record for the Excel file. Assign mappings to your existing Excel file (which is linked to your CAD model parameters) by adding a new automation record.

2.) Link the Excel cell to a project tree parameter. Choose the Excel cell you want to link via the DigiPara Liftdesigner project tree. The Excel file opens directly in DigiPara Liftdesigner.

3.) Check the link and set favorites. If the cell is correctly linked to the mapping parameter, it turns green automatically. You can add project tree parameters as global favorites (available for all existing and new projects). You can also edit or extend the Excel file directly in the dialog — for example, by defining formulas. Use the extended settings for more options.

4.) Finish the mapping and run the automation. Change the associated value and run the automation. The new value is exported to the original Excel file.

Note: The new value is written to the original Excel file, but the DigiPara Liftdesigner mapping isn't saved in it.

Result

The CAD model is driven through its Excel file: Liftdesigner writes the project value to the linked cell, and the automation updates the CAD model.

Next Step

Did this answer your question?