Borrar filtros
Borrar filtros

Extract a specific row from a struct array?

17 visualizaciones (últimos 30 días)
Ali Mahdi
Ali Mahdi el 5 de Mayo de 2021
Comentada: Ali Mahdi el 10 de Mayo de 2021
Hello everyone,
I have a bunch of excel file and I would like to extract a specific row from each file. I used the following code, but I couldn't export a specific row (let's assume the 2nd row from each file) to a new excel file.
clear all; clc
% we can use uigetfile for load multiple files
[file_list, path_n] = uigetfile('.csv', 'MultiSelect','on');
x=length(file_list);
for i=1:x
filename=file_list{i};
data_in.file_list{i}=readtable(filename);
Output.file{i}=data_in.file_list{i}(:,[ 2 5 6 9 10 11 12]);
end
for i=1:x
table{i}=Output.file{i}
disp('------------------------------')
end
% for i=1:x
% table{1, i}
% disp('----------------------')
% end

Respuestas (1)

Divya Gaddipati
Divya Gaddipati el 10 de Mayo de 2021
If you want the 2nd row from each file, you can modify the code like:
for i = 1:x
table{i} = Output.file{i}(2,:);
disp('------------------------------')
end
  1 comentario
Ali Mahdi
Ali Mahdi el 10 de Mayo de 2021
Dear Divya,
Thank you for your reply.
Ok, I got 2nd row form each excel file. How can I export these data into one excel file (i.e. one excel file contain the 2nd row of each excel file).
your helping is highly apprciated
Thank you in advance
Regards

Iniciar sesión para comentar.

Categorías

Más información sobre Data Import from MATLAB en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by