Is it possible to import an excel sheet with date&time and separate sheets by date
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
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?
2 Commenti
Risposta accettata
dpb
il 18 Ott 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.
2 Commenti
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!