Keep certain rows and deleting certain rows in excel using matlab coding

5 Ansichten (letzte 30 Tage)
I imported a few thousand rows of data into Excel and hence one data represented one row. I want to keep row no. 1, 11, 21, 31,....and so on but deleting row 2 to 10, 12 to 20, 22 to 30,.... and so on. Please anybody help me to write the coding in MATLAB.

Antworten (1)

Fangjun Jiang
Fangjun Jiang am 8 Aug. 2018
Assume your Excel file contains one column of numeric data,
a=xlsread('MyExcel.xlsx');
a=a(1:10:length(a));

Kategorien

Mehr zu Data Import from MATLAB finden Sie in Help Center und File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by