Writing cell of dates to Excel file

Question

John Cruce 2023-4-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1939404-writing-cell-of-dates-to-excel-file

评论： Adam Drake 2023-4-13

I have a cell of dates (characters - 4700x1 cell) formatted as mm/dd/yyyy. When I attempt to write to an Excel file using xlswrite, it places all the dates in one cell, with line breaks for each backslash. How might I get an Excel file with each date as a separate row within the same column?

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

请先登录，再进行评论。

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

Answer 1

Adam Drake 2023-4-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1939404-writing-cell-of-dates-to-excel-file#answer_1206644

在 MATLAB Online 中打开

Recommend using writecell and readcell instead. If you can't I will reinvestigate. Ex:

Y = [2014;2013;2012];
M = [01;02;03];
D = [31;30;31];
t = datetime(Y,M,D,'Format','MM/dd/yyyy');
datecells = cellstr(t);
filename = 'text.xlsx';
sheet = 1;
xlRange = 'B1';
writecell(datecells,filename,'Sheet',sheet,'Range',xlRange)
readcell(filename,'Sheet',sheet,'Range',xlRange)
ans = 3×1 cell array
    {'01/31/2014'}
    {'03/02/2013'}
    {'03/31/2012'}

2 个评论
显示无隐藏无

Peter Perkins 2023-4-5

在 MATLAB Online 中打开

There's no need to create that cell array, at least in recent versions of MATLAB:

writematrix(t,filename,'Sheet',sheet,'Range',xlRange)

Adam Drake 2023-4-13

The question was that they already had a cell of dates. I was just providing an example of using writecell. Everything before that was just to set that up.

请先登录，再进行评论。