How to sort Data from an Excel File...

72 ビュー (過去 30 日間)
Lauren Kilgore
Lauren Kilgore 2019 年 11 月 21 日
コメント済み: Walter Roberson 2019 年 11 月 25 日
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');
  2 件のコメント
Lauren Kilgore
Lauren Kilgore 2019 年 11 月 21 日
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?
Thanks,
Lauren

サインインしてコメントする。

採用された回答

Siriniharika Katukam
Siriniharika Katukam 2019 年 11 月 25 日
Hi
You may find a way to sort date and time from this link below:
May be you need to change the format in "datenum"
  2 件のコメント
Walter Roberson
Walter Roberson 2019 年 11 月 25 日
If you switch from xlsread() to readtable() then the first variable in the table will automatically be created as datetime() objects

サインインしてコメントする。

その他の回答 (0 件)

カテゴリ

Find more on Matrices and Arrays 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!

Translated by