利用Excel二次开发技术进行ANSYS数据后处理

大型有限元分析软件ANSYS具有强大的后处理功能,但在结构方面的应用中,所提取出的原始计算数据往往不是工程项目研究所需要的数据形式,需要进一步处理.利用嵌入在Microsoft Excel中的VBA工具,建立起Excel与输出数据之间的连接,编程实现数据的批量化自动处理,可大大简化ANSYS数据后处理的过程,避免了重复性的数据操作过程.

Postprocessor for ANSYS Data with Further Development Technology of Excel

The software ANSYS has a strong capability of postprocessing,but in the structural application,the initial calculated data are often not the needed form for the project researching,the further data postprocessing is required.The connection between Excel and the output data are built with VBA embedded in Microsoft Excel,and the progamming realizes automatic treatment in batches of the data,and these simplify the process of post processing the ANSYS data in a great deal,which avoids doing the repeating operating work about dealing with data.