Trial software

convert .xlsx file into a timetable

3 views (last 30 days)

Show older comments

Antonio Melieni on 1 Apr 2019

1
Link

Direct link to this question

https://nl.mathworks.com/matlabcentral/answers/453703-convert-xlsx-file-into-a-timetable

Commented: Ana Soph on 18 May 2020

Bildschirmfoto 2019-04-01 um 15.37.11.png

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
Show -2 older commentsHide -2 older comments

Sign in to comment.

Sign in to answer this question.

Answers (2)

Peter Perkins on 2 Apr 2019

2
Link

Direct link to this answer

https://nl.mathworks.com/matlabcentral/answers/453703-convert-xlsx-file-into-a-timetable#answer_368701

readtable + table2timetable.

If you are very up to date (R2019a), use readtimetable.

3 Comments
Show 1 older commentHide 1 older comment

Ana Soph on 18 May 2020

thanks... it works :D

Ana Soph on 18 May 2020

works with readtable, i have the R2020

Sign in to comment.

Haritha on 1 Apr 2019

0
Link

Direct link to this answer

https://nl.mathworks.com/matlabcentral/answers/453703-convert-xlsx-file-into-a-timetable#answer_368455

Hi,

Try this Link

2 Comments
Show NoneHide None

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 on 18 May 2020

i need the same please :'(

Sign in to comment.

Sign in to answer this question.

Categories

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

Find more on Spreadsheets in Help Center and File Exchange

Tags

Products

MATLAB and Simulink Student Suite

Community Treasure Hunt

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

Trial software