How do I read (hours) data from the .xlsx file?

4 次查看（过去 30 天）
stelios loizidis
stelios loizidis 2021-2-10
评论： stelios loizidis 2021-2-10
Hello,
I have the following issue. In a .xlsx file I have in column D hours (format: 00: 00: 00,01: 00: 00, ... 23:00:00). How can I integrate (read) them into the code to use them to plot some graphics I want. Your help is important.

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

采纳的回答

Walter Roberson
Walter Roberson 2021-2-10
Ran in:
[~,~,ALL_Data]=xlsread('Hours_Data.xlsx');
Hours = days(cell2mat(ALL_Data(2:25,end)));
Hours.Format = 'hh:mm';
Hours
Hours = 24×1 duration array
00:00 01:00 02:00 03:00 04:00 05:00 06:00 07:00 08:00 09:00 10:00 11:00 12:00 13:00 14:00 15:00 16:00 17:00 18:00 19:00 20:00 21:00 22:00 23:00
%OR
ALL_Data = readtable('Hours_Data.xlsx');
Hours = days(ALL_Data{:,end});
Hours.Format = 'hh:mm';
Hours
Hours = 24×1 duration array
00:00 01:00 02:00 03:00 04:00 05:00 06:00 07:00 08:00 09:00 10:00 11:00 12:00 13:00 14:00 15:00 16:00 17:00 18:00 19:00 20:00 21:00 22:00 23:00

更多回答（1 个）

KSSV
KSSV 2021-2-10
Read about readtable. In here after reading your specify the format of time. Have a look on duration.
  7 个评论
显示 5更早的评论
Walter Roberson
Walter Roberson 2021-2-10
If the answer is NO, that you have technical problems or legal restrictions that prevent you from uploading a small sample file, then just say so, and we will provide additional steps to figure out exactly what is happening. But if you were hoping for an answer soon and there is no technical or legal restriction to uploading a small sample file then upload a small sample file
We. Need. To. See. Exactly. What. Is. Stored. In. The. File.
Not what an image of it looks like. Excel permits many different kinds of data to be displayed as the same thing.

请先登录，再进行评论。

类别

在 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