How do you insert the date and time as the file name when using xlswrite?

Question

Lucas 2016-1-29

2
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/265756-how-do-you-insert-the-date-and-time-as-the-file-name-when-using-xlswrite

编辑： Stephen23 2016-1-29

Hi all,

I have seen solutions to this question but they don't appear to work when I try implementing them.

I want to create an Excel file using xlswrite, the data for the file are in a matrix called 'a'. In the matrix are data called from a server at specific times by a for loop. The loop runs for 1 hour and the halts. I want to write these data before the process starts again. I don't want to overwrite the file on the next run so I want to use xlswrite to export the data and by using the date and time in the file name each file will have a unique name.

I call the date and time using the datestr(now) function.

%%This writes a file with my data, but the file name is 'FileName'

FileName=sprintf('FileName_%s.xlsx',datestr(now)); xlswrite('FileName', a)

%%This does not work FileName=sprintf('FileName_%s.xlsx',datestr(now)); xlswrite(FileName, a)

Any help in doing this would be greatly appreciated.

Thanks,

Lucas

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Ralf 2016-1-29

15
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/265756-how-do-you-insert-the-date-and-time-as-the-file-name-when-using-xlswrite#answer_207852

在 MATLAB Online 中打开

Hi Lucas, that's because datestr(now) creates characters like colon (:) which are not allowed for file names. You should define your own date and time Format without These characters. Try

Filename = sprintf('test_%s.xlsx', datestr(now,'mm-dd-yyyy HH-MM'));
xlswrite(Filename, a)

That will work.

2 个评论
显示无隐藏无

Lucas 2016-1-29

Many thanks for your help Ralf. That works perfectly well, you have saved me a lot of time!

Luke

Stephen23 2016-1-29

编辑：Stephen23 2016-1-29

在 MATLAB Online 中打开

You might also like to consider using an ISO 8601 timestamp, which has the significant advantage that the dates then sort into the correct order when the filenames are sorted. ISO 80601 is simply the best date format: unambiguous, sortable and readable.

http://www.iso.org/iso/home/standards/iso8601.htm

To make it easy to use ISO 8601 dates and timestamps you could use my FEX submission datestr8601. By default datestr8601 uses the current time and returns the basic ISO 8601 calendar notation timestamp: this is very useful for naming files that can be sorted ASCIIbetically into chronological order!

>> datestr8601
ans =
20160129T161425
>> sprintf('test_%s.txt',datestr8601)
ans =
test_20160129T161450.txt
>> sprintf('test_%s.txt',datestr8601(now,'ymd'))
ans =
test_20160129.txt