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
采纳的回答
Maz M. Khansari
2019-10-10
0 个投票
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
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
