Can anybody help me in writing MATLAB code?i have an .xls file of 2950 sequence .i want a function to read my file and select sequence 1,11,21,31 and write it on another new .xls file, then select 2,12,22 and similarly uptill 10,20,30...etc

2 次查看(过去 30 天)

回答(1 个)

George
George 2016-11-2
% Pseudocode
T = readtable('file.xlsx');
for ii=1:10
rows = ii:10:height(T);
writetable(T(rows,:), ['filename' ii '.xlsx']);
end

Community Treasure Hunt

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

Start Hunting!

Translated by