how to get numerical values as well as texts in a single matrix after reading data from a excel file ?
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
rashmi am
el 18 de Mayo de 2015
Comentada: Star Strider
el 18 de Mayo de 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 comentarios
Respuesta aceptada
Star Strider
el 18 de Mayo de 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 comentarios
Más respuestas (0)
Ver también
Categorías
Más información sobre Get Started with MATLAB en Help Center y File Exchange.
Productos
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!