Keep certain rows and deleting certain rows in excel using matlab coding
Show older comments
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.
Answers (1)
Fangjun Jiang
on 8 Aug 2018
Assume your Excel file contains one column of numeric data,
a=xlsread('MyExcel.xlsx');
a=a(1:10:length(a));
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!