MATLAB Answers

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

10 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!!

  0 Comments

Sign in to comment.

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).

  0 Comments

Sign in to comment.


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

  0 Comments

Sign in to comment.