MATLAB: Reading of xls file without nan

read without nan

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?

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

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

data1 is overwriten each loop, use

for i=1:njump
  data1{i}=xlsread(sprintf('Trial%i.csv',i),sprintf('Trial%i',i),'A1:E7000'); % jump data
end

If you want to clear all workspace variables use

clear

% without all

The problem is the data is not in the first sheet of the .xls file.

I needed to sort the xls sheets before using

[ndata, text, alldata] = xlsread(filename)