Import Excel file to MATLAB

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?

Answer 1

[Azzi Abdelmalek]

[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

[Rodrigo Trigona]

How can i make the program read the 'T' like a numeric array?

[Rodrigo Trigona]

I need both rows read as a numeric array but this function read as a numeric and text

[Azzi Abdelmalek]

what do you mean?

[Rodrigo Trigona]

this function read only the first row as a numeric array and the second row as a text array. I need the first and second row read as numeric.

[Azzi Abdelmalek]

How is the second rows in your file numeric or text? can you post these two rows?

[Rodrigo Trigona]

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

[Azzi Abdelmalek]

can you upload your file

[Rodrigo Trigona]

http://www.4shared.com/file/VgQDgDN0/teste.html The xlsx file is in this link

[Azzi Abdelmalek]

subscript i needed to download, email me your file

[Rodrigo Trigona]

Ok

[Azzi Abdelmalek]

I see it's a text because you have dot(.) instead of comma(,)

use this to read your second rows

 l2=cellfun(@(x) str2num(x),vT(2,:))

or go to your excel file, find and replace (.) by (,)