Info
이 질문은 마감되었습니다. 편집하거나 답변을 올리려면 질문을 다시 여십시오.
New to matlab. Trying to code with excel.
조회 수: 1 (최근 30일)
이전 댓글 표시
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
답변 (1개)
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
참고 항목
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!