Effacer les filtres
Effacer les filtres

reading of xls file without nan

1 vue (au cours des 30 derniers jours)
Chandini Govind
Chandini Govind le 1 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?

Réponse acceptée

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

Plus de réponses (0)

Catégories

En savoir plus sur Large Files and Big Data dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by