I have an excel file containing text and numbers, xlsread not import the columns containing text. what should I do?
4 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
I have an excel file containing text and numbers, xlsread not import the columns containing text. what should I do?
0 Commenti
Risposte (2)
Michael Haderlein
il 3 Feb 2015
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
1 Commento
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!