Converting datenum to datetime when using writetable
3 次查看(过去 30 天)
显示 更早的评论
Hi all
I want to export some datetime data to excel. I dont know how.
In addition, for certain years, there are no values. I show this by replacing values by zero
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1354618/image.png)
A = datenum(t0_pos1); %values 2021
B = datenum(t0_pos12); %values 2022
if isempty(B)==1
B=zeros(1,1);
end
C = [];
C(:,1) = A;
C(:,2) = B;
borjan=array2table(C,'VariableNames',{'2021','2022'});
writecell(G2,'asd2.xlsx','Sheet',1,'Range','H2')
writetable(borjan,'asd2.xlsx','Sheet',1,'Range','H3')
I got numbers into excel, but I want the datenum to be converted to datetime (yy-mm-dd-hh).
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1354623/image.png)
1 个评论
Stephen23
2023-4-13
Do not convert perfectly good DATETIMEs to deprecated DATENUMs!
You can easily merge two DATETIME arrays using the EMPTY method of the appropriate class:
A = datetime(2023,1,1:9).'
B = datetime(2023,1,[])
C = datetime.empty;
C(1:numel(A),1) = A;
C(1:numel(B),2) = B
and then WRITEMATRIX as usual. Avoid deprecated DATENUM, DATESTR, and DATEVEC.
回答(1 个)
Cris LaPierre
2023-4-13
You convert your datetimes to datenums, and then write those numbers to Excel, which is what you are seeing.
Don't convert your datetimes to datenums. Then, you can use the format cells option in Excel to set the date format it gets displayed with.
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!