reading text and number from excel
81 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hello
I have this big excel file incuding text and numbers. when I use t= xlsread('table.xlsx'); it removes the columns with string automatically. when I use t = readtable('table.xlsx'); I am able to see the whole table. however, I fail to do my main job which is plotting different columns versus others . what command should i use to be able read from a table including text and number and be able to do all regular matrix function? Thanks !
t = readtable('table.xlsx')
a=t(:,4)
b=t(:,6)
plot (a,b, '.')
lsline
2 commentaires
per isakson
le 18 Jan 2019
Modifié(e) : per isakson
le 18 Jan 2019
See
[num,txt,raw] = xlsread(___)
in the documentation and try
a=t{:,4}
b=t{:,6}
Réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!