Importing Excel-Spreadsheet with columns of NaN

Hi,

I have a large dataset in an Excel-Spreadsheet which contains some columns with only NaN. The first row of the spreadsheet contains the column names (strings).

I would like to find the column names that are associated with NaN-columns. Is there a way to do this?

Thanks!

Answer 1

[nl2605]

Use xlsread. [num,txt,raw] = xlsread('filename.xlsx'); and then check with 'isnan' to get the corresponding column name.

[kanimbla]

The problem is that xlsread does not read columns which contain only NaN.

I want to identify the names of the columns which contain only NaN (not the column names which contain both numeric values and NaN).

[nl2605]

Yea, I checked it now. It seems it reads it as text and not a number which is what NaN is all about. Why don't use strcmp then? and read the txt and num columns and check.