清空筛选条件
清空筛选条件

Info

此问题已关闭。 请重新打开它进行编辑或回答。

Don't know how to fix

1 次查看（过去 30 天）
Boss Man
Boss Man 2019-12-24
关闭： MATLAB Answer Bot 2021-8-20
outdoorapr = xlsread('outdoorapr.xlsx','D2:D8586');
indoorapr=xlsread('indoorapr.xlsx','D2:D8586');
time=xlsread('time.xlsx','C2:C8586')
a=(outdoorapr);
b=(indoorapr);
t=time;
dt=diff(a)/5;
c=dt./(b(1:end-1)-a(1:end-1));%diff(a) will be one less than matrix a and b
plot(t,c);
when computing the time, i receive an empty matrix, attached are the files used, range for each of them is mentioned above. the graph produced doesnt have the time on the x axis and produces a strange curve. dont know where ive gone wrong
  2 个评论
Walter Roberson
Walter Roberson 2019-12-24
column C in time.xlsx is a macro; the actual times are stored in column B . That might make a difference in the reading.
I recommend that you switch to readtable() instead of xlsread() .
Which MATLAB release are you using?
Boss Man
Boss Man 2019-12-25
Most recent 19b

此问题已关闭。

回答（0 个）

此问题已关闭。

标签

Community Treasure Hunt

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

Start Hunting!

Translated by