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

9 次查看（过去 30 天）
tyler seudath
tyler seudath 2023-3-4
评论： 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;

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

采纳的回答

Cris LaPierre
Cris LaPierre 2023-3-4
Ran in:
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 个评论
Peter Perkins
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.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

产品


版本

R2022b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by