フィルターのクリア

Error using plot Invalid data argument (Data from Excel)

5 ビュー (過去 30 日間)
Nate Mays
Nate Mays 2021 年 3 月 9 日
コメント済み: Nate Mays 2021 年 3 月 10 日
Hello,
I'm having a problem as I try to plot two columns of data from excel (temperature over time). I keep getting the following error. (Error using plot
Invalid data argument.) My code is below.
%%Use readtable for importing data from excel%%
WData = readtable('WeatherData1.xlsx');
%(1)Determine Temperature Variations throughout the year.
%Extact High temperatures
TempH = WData{2:366,2};
y = TempH;
%Extract Low temperatures
TempL = WData{2:366,4};
%Extract Avg Temperatures
Tempavg = WData{2:366,3};
%Extract the dates
Dates = WData{2:366,1};
x = Dates;
%plot the temperture variations over the year
plot(x,y)
  23 件のコメント
Walter Roberson
Walter Roberson 2021 年 3 月 10 日
You would get that if you tried to read a header. You might need to use detectImportOptions first which was not yet automatic in your release.
Nate Mays
Nate Mays 2021 年 3 月 10 日
Appreciate it will do.

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

採用された回答

ANKUR KUMAR
ANKUR KUMAR 2021 年 3 月 10 日
You can generate dates as per the values in the excel sheet. This won't throw an error for dimension mismatch.
[~, ~, weather_data] = xlsread('WeatherData1.xlsx','Sheet1','A1:B367');
weather_data(cellfun(@(x) ~isempty(x) && isnumeric(x) && isnan(x),weather_data)) = {''};
weather_data=weather_data(3:end,:);
time=cellfun(@(x) datetime(datestr(datenum(x,'dd-mmm-yy'))) ,weather_data(:,1),'uni',0);
temp=weather_data(:,2);
plot(cat(1,time{:}),cell2mat(weather_data(:,2)))
Hope this helps.
  1 件のコメント
Nate Mays
Nate Mays 2021 年 3 月 10 日
I appreciate it. Thank you.

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

その他の回答 (0 件)

カテゴリ

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

製品


リリース

R2018b

Community Treasure Hunt

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

Start Hunting!

Translated by