I have an excel file containing text and numbers, xlsread not import the columns containing text. what should I do?
1 次查看(过去 30 天)
显示 更早的评论
I have an excel file containing text and numbers, xlsread not import the columns containing text. what should I do?
0 个评论
回答(2 个)
Michael Haderlein
2015-2-3
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
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!