Skip to main content

Step 5 of 7: Edit the Report in Excel and Load External Excel Files

EL3.5: Extend the Integration Report in Excel and Refresh in Liftdesigner

Written by Alexandra Göttert

Prerequisites

  • You've added references to the SyncWithLD sheet, set SYNC_MODE in column D, and transferred values between Excel and the project.

  • The EL3 training file Your EL3 Excel Project Integration is available (see attachment below)

Steps

Open and edit in Excel

1.) Open the report in Excel and extend it. Click Open in Excel. The .xls template file opens in Excel, where you can extend it as required.

2.) Save, close, and reload. Save and close the edited file in Excel, then reload it in DigiPara Liftdesigner with Reload report so the changes become visible.

Practical Example:

  • Create a new sheet that you might want to use later for printing or exporting.

  • Rename it and enter the names of the variables or values ​​you want to list in column A (e.g., for a BOM).

  • Link the values ​​from SyncWithLD in column B so that they also update.

3.) Save the template. Save the report as a template so you can reuse it in Liftdesigner

Load existing external Excel files

4.) Load an existing file as a template. In the Excel Reporting docking window, load an existing Excel file as a template — for example, the training file Your EL3 Excel Project Integration.

5.) Add the SyncWithLD sheet if needed. For existing Excel files that weren't generated by DigiPara Liftdesigner, add and define the SyncWithLD sheet afterwards so values can be transferred.

  • You can find this extended example in the appendix.

Result

You can extend the integration report in Excel, refresh it in Liftdesigner, save it as a template, and connect existing external Excel files to your project.

Next Step

Did this answer your question?