New to Matlab. Reading excel file problem?
3 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Aris Desai
el 10 de Oct. de 2019
Comentada: Aris Desai
el 11 de Oct. de 2019
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
0 comentarios
Respuesta aceptada
Maz M. Khansari
el 10 de Oct. de 2019
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
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!