Extract a specific row from a struct array?
11 次查看(过去 30 天)
显示 更早的评论
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
0 个评论
回答(1 个)
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
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!