Error Importing Excel Data

6 ビュー (過去 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);
  1 件のコメント
Gillian Murray
Gillian Murray 2021 年 7 月 13 日
Thank you!

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

その他の回答 (0 件)

カテゴリ

Help Center および File ExchangeSpreadsheets についてさらに検索

製品


リリース

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by