Time stamp using xlswrite
显示 更早的评论
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
2012-10-18
编辑：Azzi Abdelmalek
2012-10-18
clox=cellstr(datestr(now))
xlswrite('d:\repeati.xlsx',clox,'E5:E5');
2 个评论
Azzi Abdelmalek
2012-10-18
编辑：Azzi Abdelmalek
2012-10-18
because datestr(now) is considered as an array of string
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 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
产品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
