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

如题所述

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。

温馨提示:内容为网友见解,仅供参考
第1个回答  2020-02-11
相似回答