The Workbook File for Adams View
The workbook exported by Adams Explore from Adams View will consist of a number of tabs: a "Model" tab containing general model information and parameters followed by tabs for each of the parameter classifications for which items were selected during export which could include Points, Mass properties, Design Variables, Motions, and Splines. Editable cells are colored green and turn turquoise when their values are modified. Use the Export Model to Adams Explore Workbook dialog box help of the export dialog for details on the parameters. Finally, there is an "Analyses" tab containing information and parameters related running analyses including hyperlink to the web server.
About the File Format
The link is the a file with extension ".xlsx", the official name "Office Open XML Workbook", but more commonly known by the name borrowed from its most popular editor Microsoft Excel. The original version by the format was released with Microsoft Excel 2007 and is an open format created by Microsoft. Because of the openness, there are now more editors able to read and write the format to various degrees of compatibility. Those include LibreOffice and Google Docs. More information can be found at: https://en.wikipedia.org/wiki/Office_Open_XML. Specific information regarding xlsx editor compatibility based on MSC testing:
■Microsoft Excel 2013 has been formally tested with success
■Microsoft Excel versions prior to 2007 are not supported since they do not write the xlsx format
■Libre Office 5.2 has been formally tested with success
■Open Office is not recommended; MSC testing has shown it writes incompatible xlsx files
Adams Explore reads and writes xlsx-files using the python package openpyxl.
Important: | ■As openpyxl does not support all of the information that Microsoft Excel can export to an xlsx file, Adams Explore and openpyxl should never be made to write information to the only existing copy of a file containing critical information. If the information is not supported by openpyxl it may be removed from the file and may be lost. ■If a variable has a value that is too long to be supported by the xlsx format the following message might be given upon export: "The value of the entity '.model_1.variable_1' is too long to be stored in a cell of 'Variables'. Maximum total length is 32767. Length of '.model_1.variable_1' is 33821" ■The charts of the xlsx format only support two y-axes. Because of this, if a plot config file specified with an analysis has plots in it which has more than 2 Y-axes, the following warning is returned in the file acar.log/aview.log (of the job): "WARNING: Three y axes not supported. Skipping data added to third axis." |