What is the best way to write a duration type to an Excel file?

2 次查看（过去 30 天）
Jason Nicholson
Jason Nicholson 2016-1-14
评论： Jason Nicholson 2020-12-28
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.

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

采纳的回答

Lars Abrahamsson
Lars Abrahamsson 2020-12-23
What about the other function to create Excel files from tables?
writetable
  1 个评论
Jason Nicholson
Jason Nicholson 2020-12-28
Yes, this works in 2020b. I am not sure it works in the 2016b or 2016a that I was working in at the time.
d = duration([24;25],[0;10],[10;17]);
writetable(table(d),"example.xlsx")

请先登录，再进行评论。

更多回答（1 个）

Walter Roberson
Walter Roberson 2016-1-14
编辑：Walter Roberson 2020-12-23
https://support.microsoft.com/en-us/kb/214094
https://support.microsoft.com/en-us/kb/190633
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.

类别

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

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by