Download AXL ASAS Interface for Microsoft Excel

AXL User Manual
Overview
1. Overview
1.1 Introduction
AXL is an interface from ASAS™ to Microsoft® Excel®. It is intended to facilitate the development of
Microsoft Excel spreadsheets that require data from ASAS databases. The interface consists of a series of Excel
functions that can be accessed within the spreadsheet to recover data directly from the ASAS database. A
typical example might be an application that tabulates forces in a particular member for several load cases and
then undertakes a post-processing exercise.
Key features are:
•
Direct access to the ASAS database information using Excel Function calls
•
Recovery of element forces using element number and load case
•
Recovery of nodal displacements/reactions using node number and load case
•
Lower level functionality for recovery of keyed data from the ASAS database
•
Error trapping
•
Simple installation
•
Cross-platform interrogation of ASAS databases
1.2 Compatibility
AXL is available for Excel variants designed to run under Microsoft Windows.
The interface program does not require an ASAS dongle or security file to operate.
The interface has been designed to allow access to some non-PC versions of the ASAS database. At present
databases created on SUN, HP and SG workstations are automatically identified by the interface functions and
provide full extraction capabilities. Access to ASAS databases on other machine types will be added in due
course.
Contains proprietary and confidential information of ANSYS, Inc. and its subsidiaries and affiliates.
Page 1-1