how to get numerical values as well as texts in a single matrix after reading data from a excel file ?
2 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
rashmi am
il 18 Mag 2015
Commentato: Star Strider
il 18 Mag 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 Commenti
Risposta accettata
Star Strider
il 18 Mag 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 Commenti
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Get Started with MATLAB in Help Center e File Exchange
Prodotti
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!