MATLAB: Import Excel file to MATLAB

excelfraction numberimporting excel dataimporting number

I am trying to import a simple excel file for MATLAB but I'm having trouble with it. The file I want to import from excel is like this:
First row -> 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Second row -> 0.802 0.802 0.802 0.802 0.802 0.802 0.802 0.802 0.802 0.802 0.802 0.802 0.802 0.802 0.802 0.802 0.802 0.802 0.802 0.802 0.802 0.802 0.802 0.802 I'm using the function xlsread but in all possible forms the matlab read the fraction part like a txt file. What is the function can I use to read this file like it is?

Best Answer

[v,T,vT]=xlsread('file.xls')
%v:  numeric array  class: double
%T:  text array   class cell
%vT: both numeric and text array class cell
%or
 num=xlsread('file.xls')  % num is numeric array
Related Question