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。