MATLAB Answers

Extract a specific row from a struct array?

조회 수: 7(최근 30일)
Ali Mahdi
Ali Mahdi 2021년 5월 5일
댓글: Ali Mahdi 2021년 5월 10일
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

답변(1개)

Divya Gaddipati
Divya Gaddipati 2021년 5월 10일
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
Ali Mahdi
Ali Mahdi 2021년 5월 10일
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

댓글을 달려면 로그인하십시오.

태그

Community Treasure Hunt

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

Start Hunting!

Translated by