MATLAB Answers

reading of xls file without nan

6 views (last 30 days)
i have xls sheet as dataset and is read using xlsread(),but at the columns having single character like 'M/F' or 'Y/N' the returned output is NaN.
how to solve this?


Sign in to comment.

Accepted Answer

meghannmarie on 1 Oct 2019
Use this to get a cell array of mixed data types (doubles and char):
[~,~,raw] = xlsread('myFile.xlsx')

  1 Comment

Sign in to comment.

More Answers (0)

Sign in to answer this question.