What is the best way to write a duration type to an Excel file?
3 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Jason Nicholson
le 14 Jan 2016
Commenté : Jason Nicholson
le 28 Déc 2020
I have an array of duration type. I want to write it to Excel and then use it as a time in excel. Is there a recommended way to get this effect?
d = duration([24;25],[0;10],[10;17]);
xlswrite('Example.xlsb', d);
If you write the d to Excel, the spreadsheet will not contain any version of the duration information in d.
0 commentaires
Réponse acceptée
Lars Abrahamsson
le 23 Déc 2020
What about the other function to create Excel files from tables?
writetable
1 commentaire
Plus de réponses (1)
Walter Roberson
le 14 Jan 2016
Modifié(e) : Walter Roberson
le 23 Déc 2020
So write a serial date number which is the duration in days (and fraction of a day). You may wish to go in with ActiveX and apply a time format to the cell.
0 commentaires
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Produits
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!