I have an excel file containing text and numbers, xlsread not import the columns containing text. what should I do?

I have an excel file containing text and numbers, xlsread not import the columns containing text. what should I do?

Answer 1

[Michael Haderlein]

It does, it just returns it in another parameter. From Matlab help:

[ndata, text, alldata] = xlsread('myExample.xlsx')
ndata =
     1     2     3
     4     5   NaN
     7     8     9

text = 
    'First'    'Second'    'Third'
    ''         ''          ''     
    ''         ''          'x'    

alldata = 
    'First'    'Second'    'Third'
    [    1]    [     2]    [    3]
    [    4]    [     5]    'x'    
    [    7]    [     8]    [    9]

(<http://www.mathworks.com/help/matlab/ref/xlsread.html>)

Best regards,

Michael

[Zahra Sharifnezhadazizi]

You can use 'num2str(myExample)'

Answer 2

[Zahra Sharifnezhadazizi]

You can use 'num2str(myExample)'