What is the best way to write a duration type to an Excel file?
4 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Jason Nicholson
il 14 Gen 2016
Commentato: Jason Nicholson
il 28 Dic 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 Commenti
Risposta accettata
Lars Abrahamsson
il 23 Dic 2020
What about the other function to create Excel files from tables?
writetable
Più risposte (1)
Walter Roberson
il 14 Gen 2016
Modificato: Walter Roberson
il 23 Dic 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 Commenti
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Prodotti
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!