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

1 view (last 30 days)
aroosa batool
aroosa batool on 2 Nov 2016
Answered: George on 2 Nov 2016

Sign in to answer this question.

Answers (1)

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

Categories

Find more on Spreadsheets in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!