Unable to read strings (I get NaN) in the excel file imported into Matlab
2 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentare
Antworten (2)
Lucademicus
am 2 Jan. 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 Kommentare
Amit
am 2 Jan. 2020
Import the exel data with option cell array output type, not as Numeric matrix.
0 Kommentare
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!