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

조회 수: 1 (최근 30일)
Abdul Rahim Mahayadin
Abdul Rahim Mahayadin 2018년 8월 8일
답변: Fangjun Jiang 2018년 8월 8일
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.

이 질문에 답변하려면 로그인하십시오.

답변 (1개)

Fangjun Jiang
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));

카테고리

Help Center 및 File Exchange에서 Data Import from MATLAB에 대해 자세히 알아보기

태그

Community Treasure Hunt

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

Start Hunting!

Translated by