Write one year date into a excel?

2016 4 13
1 个回答
回答已采纳
更新时间：2016 4 13
2 次查看（30 天）

0 个投票

If I want to write one year date into a excel, like year 2016. I have no idea how to code in matlab. Thanks
1/1/2016
1/2/2016
...
..
12/31/2016

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

 采纳的回答

Azzi Abdelmalek
Azzi Abdelmalek 2016-4-13
编辑：Azzi Abdelmalek 2016-4-13

0 个投票

out=datestr(datenum('01/01/2016')+datenum(0:365),'mm/dd/yyyy')
xlswrite('your_file.xlsx',out)

6 个评论
显示 4更早的评论 隐藏 4更早的评论

Jason
Jason 2016-4-13
This code will output 01/01/2016, can you remove zero?
Jason
Jason 2016-4-13
I just tried that we need not the code. In Excel, when we enter 1/1/2016, then drag the cell, the following cells will increase the date automatically
Andrei Bobrov
Andrei Bobrov 2016-4-13
out=datestr(datenum('01/01/2016')+(0:365)','mm/dd/yyyy');

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Time Series Objects 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by