#### 2.1.1.6. Excel Spreadsheet Interaction

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 synchonized. 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.

Figure : Excel Link Dialog

The main functions of the Excel Link are:

- Open Excel: 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.

- Push to: Sync lay-up definition data from ACP to Excel.

- Pull from: Read definition data from Excel and update the definition in ACP.

The following options are available for Pull Mode:

- Update Lay-up: During a Pull from operation, definitions are updated, additional plies are generated and deleted according to Excel data.

- Update Properties Only: During a Pull from operation, definitions are updated with properties given.

- Recreate Lay-up: During a Pull from operation, existing lay-up is deleted and generated from scratch.

The format of the Excel spreadsheet is described in Tabular Data Format for Excel.

Figure : Excel Link Creates a Worksheet for Every Modeling Group

Release 18.2 - © ANSYS, Inc. All rights reserved.