Error Importing Excel Data

10 次查看（过去 30 天）
Gillian Murray
Gillian Murray 2021-7-9
评论： Gillian Murray 2021-7-13
Just yesterday I was able to import a table with 3 columns, one titled Time with datetime data, the second titled Steps with numeric data, and a third titled ActionType with Out of Work, Sleep, Work, Exercise, and Non-Wear. Now when I go to import it, it says the cells Time and Steps are not importable, but the rest of it is. I tried to get around this by importing just the values for Time and labeling the variable time and doing the same for steps, but when I call bar, I get an error:
S = Steps;
>> T = Time;
>> b = bar(S, T);
Error using bar (line 139)
Input arguments must be numeric, datetime, duration or categorical.
I have no clue what happened, I greatly appreciate any help!

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

采纳的回答

KSSV
KSSV 2021-7-9
T = readtable(myfile) ;
S = T.(2);
T = T.(1);
b = bar(S, T);

更多回答（0 个）

类别

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

标签

产品


版本

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by