reading of xls file without nan

1 view (last 30 days)
Chandini Govind
Chandini Govind on 1 Oct 2019
Commented: Chandini Govind on 2 Oct 2019
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?

Sign in to answer this question.

Accepted Answer

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

More Answers (0)

Categories

Find more on Large Files and Big Data in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!