: Create, edit, or save the entities such as
Look-up Tables or Modeling Plies with Excel.
The Excel Link interface allows you to define, modify, or save the lay-up definition in an Excel spreadsheet. The lay-up can be transferred to a spreadsheet using the push function or a lay-up which has been defined in a spreadsheet can be imported into ACP using the pull function. By default, all lay-up data is synchronized between Excel and ACP. Alternatively, you can select specific Modeling Groups for which the lay-up is synchronized. In addition, Pull Mode controls how the lay-up is transferred to ACP. The lay-up can be linked to a new spreadsheet or to an existing one. The latter functionality gives you the ability to restore a lay-up from pre-defined data.
The main functions of the Excel Link are:
: Open an existing Excel file if specified. If no path is specified, a new worksheet is opened and filled with the current lay-up information.
: Sync lay-up definition data from ACP to Excel.
: Read definition data from Excel and update the definition in ACP.
: Close Excel and the ACP Dialog Box
The following options are available for Pull Mode:
Update Entities: During a operation, definitions are updated, additional plies are generated and deleted according to Excel data.
Update Properties Only: During a operation, definitions are updated with properties given.
Recreate Entities: During a operation, existing lay-up is deleted and generated from scratch. The ACP Tree order corresponds to the Excel spreadsheet order.