how to get numerical values as well as texts in a single matrix after reading data from a excel file ?
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
rashmi am
le 18 Mai 2015
Commenté : Star Strider
le 18 Mai 2015
[num,txt]=xlsread(filename,sheet) here num contains all numerical value and nan (not a number)and txt contains all the texts.now ,how can i replace these nan elements in num by the elements of txt?
0 commentaires
Réponse acceptée
Star Strider
le 18 Mai 2015
The easiest way (not having your file to test this on) is to add a third output to xlsread:
[num,txt,raw]=xlsread(filename,sheet)
The ‘raw’ output should have everything just as the function imported it.
3 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Get Started with MATLAB dans Help Center et File Exchange
Produits
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!