Keep certain rows and deleting certain rows in excel using matlab coding
1 次查看(过去 30 天)
显示 更早的评论
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.
0 个评论
回答(1 个)
Fangjun Jiang
2018-8-8
Assume your Excel file contains one column of numeric data,
a=xlsread('MyExcel.xlsx');
a=a(1:10:length(a));
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!