Question

怎么把excel中的数据导入matlab中？

Answer 1

excel中的数据导入matlab中的方法：

1、你可以使用xlsread函数来读取excel中的数据

2、就是把字符转化为数字，使用函数str2num

xlsread的使用：

EXAMPLES:

1. Default operation，

NUMERIC = xlsread(FILE)，

[NUMERIC,TXT]=xlsread(FILE)，

[NUMERIC,TXT,RAW]=xlsread(FILE)。

2. Get data from the default region:

NUMERIC = xlsread('c:\matlab\work\myspreadsheet')。

3. Get data from the used area in a sheet other than the first sheet:

NUMERIC = xlsread('c:\matlab\work\myspreadsheet','sheet2')。

4. Get data from a named sheet:

NUMERIC = xlsread('c:\matlab\work\myspreadsheet','NBData')。

5. Get data from a specified region in a sheet other than the first：

sheet，

NUMERIC = xlsread('c:\matlab\work\myspreadsheet','sheet2','a2:j5')。

6. Get data from a specified region in a named sheet:

NUMERIC = xlsread('c:\matlab\work\myspreadsheet','NBData','a2:j5')。

7. Get data from a region in a sheet specified by index:

NUMERIC = xlsread('c:\matlab\work\myspreadsheet',2,'a2:j5')。

8. Interactive region selection:

NUMERIC = xlsread('c:\matlab\work\myspreadsheet',-1)，

You have to select the active region and the active sheet in the，

EXCEL window that will come into focus. Click OK in the Data ，

Selection Dialog when you have finished selecting the active region。

Answer 2