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

1 visualizzazione (ultimi 30 giorni)
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.

Risposte (1)

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

Categorie

Scopri di più su Data Import from MATLAB in Help Center e File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by