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





