Unable to read strings (I get NaN) in the excel file imported into Matlab
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
I am importing an Excel file that has both strings and numeric values. Eventhough I can see the springs value during the importation (using the import data tool), I m unable to see those strings after I run my code an extract the rows I want. I see NaN instead of the string values. Please, what should I do? Thank you!!
0 comentarios
Respuestas (2)
Lucademicus
el 2 de En. de 2020
I have made an Excel file with a column containing numbers and strings.
The result of importing depends on what data you tell MATLAB to expect, and how to treat other data types.
In this preview, I have highlighted how MATLAB's tells me a value will be treated as NaN:
If you want to have mixed numbers and strings, you should choice Cell Array as Output Type (whereas it is Table, in my example).
0 comentarios
Amit
el 2 de En. de 2020
Import the exel data with option cell array output type, not as Numeric matrix.
0 comentarios
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!