extract date from cell of mixed types

Question

Utsav 2016-3-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/275026-extract-date-from-cell-of-mixed-types

回答： BhaTTa 2024-11-21，4:22

[dom,txt11,raw11]=xlsread('datasheet.xls',9,'A:A'); yields [] for dom, cell for txt11 and for raw 11 the following is output 'Date' '01/06/2014' '02/06/2014' '05/06/2014' 'NaN' 'NaN' I wish to get the day information from the raw11 data. day(),month(), etc in excel are throwing garbage and I cant use their output to MATLAB.

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

请先登录，再进行评论。

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

Answer 1

BhaTTa 2024-11-21，4:22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/275026-extract-date-from-cell-of-mixed-types#answer_1547608

Hey @Utsav, When you import data from Excel using xlsread in MATLAB, and the date information is stored as text, you need to convert these text representations into MATLAB's datetime format to extract the day, month, or other components. Here’s how you can do it:Steps to Extract Day Information

Read the Data: Use xlsread to import the data.
Convert Text to Datetime: Use datetime to convert the text data into datetime objects.
Extract Day Information: Use the day function to extract the day from the datetime objects.