Extract a specific row from a struct array?

29 views (last 30 days)
Ali Mahdi
Ali Mahdi on 5 May 2021
Commented: Ali Mahdi on 10 May 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

Answers (1)

Divya Gaddipati
Divya Gaddipati on 10 May 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 Comment
Ali Mahdi
Ali Mahdi on 10 May 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

Sign in to comment.

Categories

Find more on Data Import from MATLAB in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!