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

2 次查看(过去 30 天)
I have an excel file containing text and numbers, xlsread not import the columns containing text. what should I do?

回答(2 个)

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)'

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by