Error using datetime Input data must be one numeric matrix when converting from a different date/time representation.

Question

tyler seudath 2023-3-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1923135-error-using-datetime-input-data-must-be-one-numeric-matrix-when-converting-from-a-different-date-tim

评论： Peter Perkins 2023-3-13

Hi Everyone,

I am trying to export time data from excel and to but in format HH:mm and remove the date and year but I am getting the error "Error using datetime Input data must be one numeric matrix when converting from a different date/time representation."

The code is attached:

[file,path] = uigetfile('*.xlsx','Select a File'); %Opening modal dialog box to get the excel file (xlsx ensures that only excel files are shown)
            fpath=[path,file];  % File path of excel file
            app.FilePathEditField.Value=fpath; % Assigning the file path to the edit field area
            app.H = readtable(app.FilePathEditField.Value);
            app.H.Time_24HourClock_= datetime(app.H.Time_24HourClock_,'ConvertFrom','excel','Format','HH:mm');% Here has the error
            app.UITable.Data =app.H; 
        

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

请先登录，再进行评论。

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

Answer 1

Cris LaPierre 2023-3-4

在 MATLAB Online 中打开

We really need to know more about your variable values to say for certain, but I suspect what is happening is that readtable has already read the Time_24HourClock_ data as a datetime. So the error is likely caused by passing a datetime variable as input to datetime.

D = datetime('now');
datetime(D,'ConvertFrom','excel','Format','HH:mm')
Error using datetime
Input data must be one numeric matrix when converting from a different date/time representation.

To change the display format of your table variable Time_24HourClock_, try the following:

app.H.Time_24HourClock_.Format = 'HH:mm';

2 个评论
显示无隐藏无

tyler seudath 2023-3-4

Thanks a mil! It worked.

Peter Perkins 2023-3-13

In addition:

Changing the display format does nothing to the actual datetime values in app.H.Time_24HourClock_. They are still dates and times. If your goal is to treat them as times-of-day, you may well be better off calling timeofday on that table variable rather than changing its display format. Hard to tell, though.

请先登录，再进行评论。