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

2 views (last 30 days)
Stefan Azzopardi
Stefan Azzopardi on 18 Oct 2018
Commented: dpb on 19 Oct 2018
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?

Accepted Answer

dpb on 18 Oct 2018
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.

Sign in to comment.

More Answers (0)




Community Treasure Hunt

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

Start Hunting!