### 2.3.4. Tabular Data Format for Excel

A definition block starts with a cell value of BEGIN TABLE and ends with END TABLE. This cell is in the first column (A) of the worksheet. The block DEFINITION is used to identify the type of tabular data defined in the block. ModelingGroup is currently the only supported definition type.

Empty lines are not allowed inside of sub-blocks. Lines between sub-blocks are ignored. The formatting of existing cells is not changed when the lay-up is pushed from ACP. Missing field in the DATA block are ignored and not set when synchronized with ACP. Hidden cells are not ignored and are synchronized with ACP.

Figure : Tabular Format in Excel

References to other objects (ply material, oriented selection sets, etc.) are defined by the object's ID. In the case of ply material, the type of material and the material's ID are joined with a forward slash (for example, fabrics/E-Glass). For the angle and thickness fields, the column name and the ID of the lookup table must be provided (LookUpTable.1/Angle).

Communication to Excel is accomplished through the COM interface. The identifier used to connect to Excel is Excel.Application.

You can find more information on how to exchange model data with Excel in Excel Spreadsheet Interaction.

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