实现MATLAB与Excel数据交互的一种可行方法

实际工程设计及数据处理过程中,经常需要在MATLAB环境中读取Excel工作表中的数据。通常的方法是利用Excel Link插件做接口,在两软件之间实现数据交互。而一种更为快捷可行的新方法,对工作表中的数据进行操作时,可不必考虑数据的格式,有利于程序的编制和数据的管理。该方法已用于链传动系统的仿真分析中,验证了数据交互的可行性。

A Feasible Method for the Data Communication Between MATLAB and Excel

In treatments with engineering designs and data processes relevant to MATLAB,it' s often needed to read and write datum from Excel. Usually the Excel link as a misconnected port to perform data intercourse between MATLAB and Excel is used. A new feasible method based on the control of program sentences is presented. The datum on excel tables can be treated without considering its formats,and the programming and data treatments can be easily realized. The method has been applied to the analysis of the chain ...