convert .xlsx file into a timetable

Hi :)
I have the following excel sheet and I want to convert it into a time table.
The first row should be the "datetime" row in the format 'dd.mm.yyyy HH:MM:SS' and the following rows should be double
Can anyone help me :)

Answers (2)

Peter Perkins
Peter Perkins on 2 Apr 2019
readtable + table2timetable.
If you are very up to date (R2019a), use readtimetable.

3 Comments

doesn't work for me
thanks... it works :D
works with readtable, i have the R2020

Sign in to comment.

Haritha
Haritha on 1 Apr 2019
Hi,
Try this Link

2 Comments

Thx, but i want to import an xlsx file and have it as a timetable in matlab
i need the same please :'(

Sign in to comment.

Asked:

on 1 Apr 2019

Commented:

on 18 May 2020

Community Treasure Hunt

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

Start Hunting!