Info

此问题已关闭。 请重新打开它进行编辑或回答。

New to matlab. Trying to code with excel.

1 次查看（过去 30 天）
Aris Desai
Aris Desai 2019-10-11
关闭： MATLAB Answer Bot 2021-8-20
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

此问题已关闭。

回答（1 个）

Turlough Hughes
Turlough Hughes 2019-10-11
[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'
  1 个评论
Aris Desai
Aris Desai 2019-10-16
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

此问题已关闭。

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by