reading of xls file without nan

hi

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?

Answer 1

[meghannmarie]

Use this to get a cell array of mixed data types (doubles and char):

[~,~,raw] = xlsread('myFile.xlsx')

[Chandini Govind]

tnk u