Is it possible to import an excel sheet with date&time and separate sheets by date

2 次查看（过去 30 天）
Stefan Azzopardi
Stefan Azzopardi 2018-10-18
评论： dpb 2018-10-19
I have multiple monthly excel sheets each having a big number of columns and rows. The first column of each sheet contains the date and time for data taken every 5 mins for a month period. Is it possible that I import the sheet on matlab and save in different sheets for each day?

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

采纳的回答

dpb
dpb 2018-10-18
Sure, just read in and use the datetime data to group by day. See very similar Q? asked here Split data for each date
Note there are two ways to "skin the cat" there; one using a timeseries object and another just using the datetime data directly.
  2 个评论
Stefan Azzopardi
Stefan Azzopardi 2018-10-19
To be honest I have found that post previously but did not understand much of it. So the best way, correct me if I m wrong please, is to convert the table into a timetable and then try to use datetime dta directly?

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2017a

Community Treasure Hunt

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

Start Hunting!

Translated by