Matlab与Excel数据交互方法及其在CAE中的应用

为提高CAE前、后处理中数据处理的效率,介绍了三种Matlab与Excel数据交互的方法(函数法、动态数据交换法以及Excel Link插件),并以绘制汽车某型号钢材的力学性能曲线为例,介绍各自的特点与使用局限。结果表明,三种方法的实现原理不尽相同,但实现的结果一致,都能实现数据的读写操作,在交互处理数据上都具有一定的方便性和快捷性,且适用于不同的场合。

Application of Data Exchange Methods Between Matlab and Excel in CAE

Three methods of data exchange are introduced to improve the efficiency of data processing during pre-processing and post-processing in this paper.As an example of application,the mechanics performance curve of some steel is drawn to demonstrate the strong points and shortage of them.The results show that the realization principles of three methods are different,but the results are almost the same.All of them can carry out the reading and writingof data.They are more convenient in data exchange and suitable for different situations.