中文说明:Excel是一款非常优秀的通用表格软件,在学习、工作与科研中大量的数据可能都是以excel表格的方式存储的。Excel在矩阵计算、数据拟合与优化算法等方面的功能尚不足,Excel与Matlab相结合是处理复杂数据问题的有效方法。 如何利用matlab强大的数值计算功能处理excel中的数据,首要解决的问题就是如何将excel中的数据导入到matlab中或将matlab数值计算的结果转存入excel中,本章主要介绍以函数方式与exlink宏的两种方法实现matlab与excel的数据交互。
English Description:
General forms for Excel is a very good software, study, work and research of large amounts of data may be stored in Excel tables. Excel in matrix computation, and optimization algorithm of data fitting function is insufficient, combining Excel and Matlab are effective methods for dealing with complex data. How to use the MATLAB function of numerical calculation of processing power of Excel data, essential problem is how do I import data from Excel to MATLAB or MATLAB in numerical calculation results into Excel, this chapter describes how to function with exlink macro-realization of MATLAB to interact with Excel data in two ways.