New to Matlab. Reading excel file problem?

I am new to matlab and I am trying to read an excel file. This is what I need it to read. Each column will be a seperate name listed in the first row. Below each column has a "1" extending for x amount of rows. I am trying to store the number of those "1's" as the amount per columns

Basically this,

Name1 Name2

1 1

1 1

1 1

1 1

1 1

1 1

1 1

1 1

1 1

1 1

1 1

1 1

1

1

1

1

1

Answer 1

[Maz M. Khansari]

The following script will do what you need. Remove semicolon to get the output. provide the name of your excel file to xlsread function.

[values,header] = xlsread('x.xlsx'); % read excel file

col_1 = values(:,1); % get values of first column

col_1 = col_1(~isnan(col_1)); % remove nans, if any

numel(col_1); % count number of values in the first column

col_2 = values(:,2); % get values of second colum

col_2 = col_2(~isnan(col_2)); % remove nans, if any

numel(col_2); % count number of values in the first column

[Aris Desai]

Thank you.

Is there a way to loop it where if i have multiple columns with different amount of numbers i can store it in that column name andhave it post in the name of the column and under it the amount of numbers.

Name1 Name2 Name3 ..........(etc)

1 1 1

1 1 1

1 1 1

1 1 1

1 1

1 1

1

1

1