Error using datetime Input data must be one numeric matrix when converting from a different date/time representation.
11 views (last 30 days)
Show older comments
tyler seudath on 4 Mar 2023
Commented: Peter Perkins on 13 Mar 2023
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
Cris LaPierre on 4 Mar 2023
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');
To change the display format of your table variable Time_24HourClock_, try the following:
app.H.Time_24HourClock_.Format = 'HH:mm';
Peter Perkins on 13 Mar 2023
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.
More Answers (0)
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!Start Hunting!