MATLAB Answers

reading of xls file without nan

4 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')

More Answers (0)

Community Treasure Hunt

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

Start Hunting!

Translated by