Skip to main content

Step 4 of 7: Transfer Values Between Excel and DigiPara Liftdesigner

EL3.4: Values flow between the Excel and Liftdesigner

Written by Alexandra Göttert

Prerequisites

  • The Excel Reporting docking window is open, and you've created a new Excel Project Integration report (saved next to the .ld3 file) that contains the prepared sync sheet.

Steps

The SyncWithLD sheet of the report handles the transfer between the Excel report and DigiPara Liftdesigner, using DigiPara Liftdesigner references.

1.) Add a reference to the SyncWithLD sheet. Copy the reference of a project value from the Data tree and paste it into column A of a new row in the SyncWithLD sheet.

2.) Define the sync mode in column D. Set column D (SYNC_MODE) for the new reference. Only after column D is defined is the associated value displayed in column B. The sync mode determines whether you:

  1. read the current DigiPara Liftdesigner value into the Excel report,

  2. transfer values entered in Excel back to the DigiPara Liftdesigner project, or

  3. do both (read and transfer).

Note: Only values that are directly editable in DigiPara Liftdesigner can be changed via the Excel Project Integration. Values that aren't directly editable — such as shaft dimensions (appear gray in Edit Mode.)

3.) Change a value and transfer it to the project. Enter a new value for the car depth (Shaft0.Car.CD) in column B and transfer it to the DigiPara Liftdesigner project by clicking the Apply changes button, which is highlighted in red after a change has been made. Check that the change appears in the project, like on the drawing.

Result

Values flow between the Excel report and the project: Excel shows current Liftdesigner values, and editable values you change in Excel are transferred back to the project.

Next Step

Did this answer your question?