New to matlab. Trying to code with excel.

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 under each column/name. I am trying to loop this so that i can have multiple columns if necessary.

Basically this,

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

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

[Stephen23]

https://www.mathworks.com/help/matlab/ref/readtable.html

Answer 1

[Turlough Hughes]

[data,varnames]=xlsread('myfilename.xlsx')
sumdata=sum(data);                                    % sumation of columns
T=array2table(sum(data),'VariableNames',varnames)     % Table of results plus corresponding column title

If your file is located in your working directory you can refer you can read it in as above. Otherwise, you will need to specify the full address of your file e.g.

'C:\...\myfilename.xlsx'

[Aris Desai]

Thank you this works!!! Is there a way to do this without using sumdata and array2table. I know its harder but I wanted to learn how to make a loop to possibly return the same data?

Thanks