writing date on an excel sheet

8 次查看（过去 30 天）

显示更早的评论

S 2011-8-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/14451-writing-date-on-an-excel-sheet

编辑： Prieni 2017-8-18

采纳的回答： Oleg Komarov

Hi folk,

Got a question about writing date on an excel sheet. I am using the following codes:

DATE=datestr(now);

xlswrite('test.xls', DATE, 'A1')

The problem is that it separates each number and letter and put them in separate cells. I want the whole date in one cell like 'A1' but it appears from 'A1' to 'T1'

I appreciate your help. Thank you.

S:-)

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Prieni 2017-8-18

编辑：Prieni 2017-8-18

Just came across the problem to export date/time to an Excel sheet. If you do this:

DATE = now - datenum(1899,12,30,0,0,0);

xlswrite('test.xls',DATE)

you get a number in your Excel sheet that, if you change formatting to date, shows the current date. It also includes the current time which you can see when you select that date.

请先登录，再进行评论。

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