MATLAB Answers

convert .xlsx file into a timetable

17 views (last 30 days)
Antonio Melieni
Antonio Melieni on 1 Apr 2019
Commented: Ana Soph on 18 May 2020
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 :)

  0 Comments

Sign in to comment.

Answers (2)

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

  3 Comments

Ana Soph
Ana Soph on 18 May 2020
thanks... it works :D
Ana Soph
Ana Soph on 18 May 2020
works with readtable, i have the R2020

Sign in to comment.


Haritha
Haritha on 1 Apr 2019
Hi,
Try this Link

  2 Comments

Antonio Melieni
Antonio Melieni on 1 Apr 2019
Thx, but i want to import an xlsx file and have it as a timetable in matlab
Ana Soph
Ana Soph on 18 May 2020
i need the same please :'(

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!