第一种方法，你可以使用xlsread函数来读取excel中的数据
第二种方法，就是把字符转化为数字，使用函数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。 以上是对这个问题的回答，希望对您有帮助。