xlsread: NaN is not recognized as Numeric Data

I like to import data from the file 'test.csv' (see attachment) into matlab. I use following code:

[Data, Time] = xlsread('test.csv')

Problem: The numeric data that is returned doesn't include the NaN data from the first rows. It looks like that xlsread doesn't include the NaN data if the whole row consists only of NaN Data. For my routine the NaN data from the first rows needs to be returned also.

Thx for your help. Chris

[brian zhang]

try to convert data to string you will get NaN not a number. I bet convert back to number will not be 'NaN'. Logic return will be 0 which is an error.

Answer 1

[chris_andreas]

Hi! I found a solution: With the function "importdata" the data is imported the "right" way.

Answer 2

[dpb]

My release of Excel doesn't have NaN as a numeric entity; suspect it's not being returned because it isn't numeric. Look at the alternate outputs of xlsread, text, and raw. You'll likely have to process the raw text array.

Answer 3

[Muhammad Usman Saleem]

convert this csv file into excel. Then try to read

xlsread('test.csv')

or you have another option if NAN values are not read by xlsread. Change in csv file NaN value with arbitary value like -999999 then try to read them. After then you can change this value with NaN as

find(data=-999999)=nan;

tell me please