Time stamp using xlswrite

2 次查看（过去 30 天）
Tim
Tim 2012-10-18
编辑： Zargham Ali 2015-7-20
Hi all,
I want to put a time stamp next to the data that I export to excel. Hence, I did this:
clox=datestr(now)
xlswrite('d:\repeati.xlsx',clox,'E5:E5');
However, this will just display a '1' in my excel file. What am I doing wrong?
Cheers, T.

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

采纳的回答

Azzi Abdelmalek
Azzi Abdelmalek 2012-10-18
编辑：Azzi Abdelmalek 2012-10-18
clox=cellstr(datestr(now))
xlswrite('d:\repeati.xlsx',clox,'E5:E5');
  2 个评论
Azzi Abdelmalek
Azzi Abdelmalek 2012-10-18
编辑：Azzi Abdelmalek 2012-10-18
because datestr(now) is considered as an array of string
Zargham Ali
Zargham Ali 2015-7-20
编辑：Zargham Ali 2015-7-20
@AzziAbdelmalek What to do if we need multiple timestamps on hourly basis? %start time stime=datenum(2012,1,2,0,0,0) %end time etime=datenum(2012,1,2,23,00,00) %length of time step (1D, 3min in this case) delta=datenum(0,0,0,1,0,0) %ymdhms for nw=stime:delta:etime clox=cellstr(datestr(nw))
end xlswrite('MERRA.xlsx',clox,'Sheet1','A2');
it just gives me the last hour that is 23:00.
I would be very grateful for your help. Regards

请先登录，再进行评论。

更多回答（1 个）

类别

在 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