필터 지우기
필터 지우기

Load Data from Excel sheet with set interval of data

조회 수: 5 (최근 30일)
Jack B
Jack B 2014년 10월 19일
댓글: Image Analyst 2014년 10월 19일
Hello all,
I have a question that may prove to be simpler than I may think. I want to load data from an excel sheet into matlab to process. I have over 30,000 data points with data collected at particular date and time.
I have 30 cells, and each cell begins at the same time and ends at the same time. Now there is only a range of data I required that repeats every cell and the rest is not needed. How do I isolate just that repeating range instead of manually complete this daunting task.
There seems to be no way to do it in excel so I thought I'd use the more useful software.
Here is also a sample of my data I want analyse to make visualising this process better.
  댓글 수: 1
Image Analyst
Image Analyst 2014년 10월 19일
Please attach your workbook so people can try some things. Also, it's not clear what rows you want to keep and what rows you want to discard. Do you want only row 3 and whatever row "Cell 1" ends at? Or do you just want the first instance of the times, like rows 3, 5, 7, 9, etc. (all the odd rows)?

댓글을 달려면 로그인하십시오.

답변 (0개)

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by