CivilFEM Online Help

~VWXLS

 

~VWXLS, Filename, Exit, Title, PLT_PRM, ARRAY0, ARRAY1, ARRAY2, ... , ARRAY15

Exports numerical arrays created from ANSYS or CivilFEM commands to Microsoft Excel

DATABASE: Parameter

Filename

Name of the file without including the extension (8 characters maximum).

EXIT

Exporting behavior.

0	Leave EXCEL opened after exporting the results (default value).
1	Leave EXCEL opened and save the file. The program asks if the user wants to replace the file if it already exists.
2	Leave EXCEL opened and save the file replacing any existing file with the same name.
3	Save the file replacing any existing file with the same name and close EXCEL.

Title

Graphic title (32 characters maximum).

PLT_PRM

Graphic parameters. It is an array with a component for each series.

The value (absolute value) indicates the color of the series. If positive, the component is represented in the main axis. If negative, it is represented in the secondary axis.

ARRAY0

X-axis values against which the arrays of the series will be represented.

ARRAY1-ARRAY15

Series.

Notes

-  This command works at any processor.

-  This command creates a Microsoft Excel workbook with two sheets in which the exported data are stored. The exported vectors are stored into columns in CivilFEM Data sheet. The header of each vector coincides with its name in ANSYS.

-  The vectors are represented in an Excel XY graphic with the user-selected options in the CivilFEM Graphic sheet.

-  Numerical vectors of any length can be exported. The vectors may be created with any ANSYS or CivilFEM commands.

-  The following colors, corresponding to the predefined Excel colors, are used in the PLT_PRM field:

Menu Paths

Main Menu > Civil Postprocessor > Utils > Excel Interface

¾¾¾¾¾¾¨¾¾¾¾¾¾