strings and numbers from excel
4 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Hi, I need to read table from excel. This table are filled with numers and strings and some cells are empty. Is there easy way to read such table in one matrix? Because now matlab just creates to matrices: one with strings and another with numbers and NaN's where strings used to be.
Thanks in advance.
0 comentarios
Respuesta aceptada
Fangjun Jiang
el 24 de Mayo de 2011
Use the third returning argument of xlsread()
[NUMERIC,TXT,RAW]=XLSREAD(FILE)
I always prefer this way because then I can process the RAW information as I need. Some helpful functions are, isnan(), isnumeric()
0 comentarios
Más respuestas (1)
the cyclist
el 24 de Mayo de 2011
I have used the following entry from the File Exchange with success:
0 comentarios
Ver también
Categorías
Más información sobre Spreadsheets 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!