Load Data from Excel sheet with set interval of data

4 次查看（过去 30 天）

Jack B 2014-10-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/159240-load-data-from-excel-sheet-with-set-interval-of-data

评论： 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 个评论
显示 -1更早的评论隐藏 -1更早的评论

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)?

请先登录，再进行评论。

请先登录，再回答此问题。