How to sort Data from an Excel File...

30 views (last 30 days)
I am wanting to create a code that will read from an Excel file (I have attached an example below). I want the total number of students, check-in types to be sorted, and for the date and time to be sorted. I am very new to Matlab and this would help make my job much easier!
[~,~,rawData] = xlsread('matlabproject.xlsx');
Lauren Kilgore
Lauren Kilgore on 21 Nov 2019
Hi Walter,
Thank you so much! It works! Would you possibly know how to sort the date and time or direct me to some reasources to figure it out?

Sign in to comment.

Accepted Answer

Siriniharika Katukam
Siriniharika Katukam on 25 Nov 2019
You may find a way to sort date and time from this link below:
May be you need to change the format in "datenum"
Walter Roberson
Walter Roberson on 25 Nov 2019
If you switch from xlsread() to readtable() then the first variable in the table will automatically be created as datetime() objects

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!

Translated by