reading of xls file without nan

2 vues (au cours des 30 derniers jours)
Chandini Govind
Chandini Govind le 1 Oct 2019
Commenté : Chandini Govind le 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?

Connectez-vous pour répondre à cette question.

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 Text Files dans Help Center et File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by