reading of xls file without nan

3 次查看（过去 30 天）

Chandini Govind 2019-10-1

评论： Chandini Govind 2019-10-2

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?

meghannmarie 2019-10-1

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

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

Chandini Govind 2019-10-2

tnk u

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Text Files

在 Help Center 和 File Exchange 中查找有关 Text Files 的更多信息

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

Translated by