Unable to read strings (I get NaN) in the excel file imported into Matlab

17 views (last 30 days)
Faichal Ayeva
Faichal Ayeva on 2 Jan 2020
Answered: Amit on 2 Jan 2020
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!!

Answers (2)

Lucademicus
Lucademicus on 2 Jan 2020
I have made an Excel file with a column containing numbers and strings.
mat.PNG
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:
mat3.PNG
If you want to have mixed numbers and strings, you should choice Cell Array as Output Type (whereas it is Table, in my example).

Amit
Amit on 2 Jan 2020
Import the exel data with option cell array output type, not as Numeric matrix.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!