Error using plot Invalid data argument (Data from Excel)

2 次查看（过去 30 天）

显示更早的评论

Nate Mays 2021-3-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/767827-error-using-plot-invalid-data-argument-data-from-excel

评论： Nate Mays 2021-3-10

采纳的回答： ANKUR KUMAR

在 MATLAB Online 中打开

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 个评论
显示 21更早的评论隐藏 21更早的评论

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 2021-3-10

Appreciate it will do.

请先登录，再进行评论。

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

采纳的回答

ANKUR KUMAR 2021-3-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/767827-error-using-plot-invalid-data-argument-data-from-excel#answer_644367

在 MATLAB Online 中打开

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)))