How do I select particular data from excel file

3 次查看（过去 30 天）
Debayan Mandal
Debayan Mandal 2018-12-4
评论： Debayan Mandal 2018-12-4
I have an excel file with 2 colum title namely date and time , value. I want each date 14:30 value only. Is it possible to do so?
thanks in advance

请先登录，再回答此问题。

采纳的回答

Kevin Chng
Kevin Chng 2018-12-4
编辑：Kevin Chng 2018-12-4
Yes. Try
a = readtable('test.xlsx');
b = a((hour(a.Date_Time)==14 & minute(a.Date_Time)==30),:)
Use logic to get the index of a when hour is 14 and minutes is 30.
Accept my answer if it is working for you.

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by