define the cell array size for excel data

1 次查看（过去 30 天）

sunitha 2021-2-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/739097-define-the-cell-array-size-for-excel-data

评论： sunitha 2021-2-9

i have given different inputs to known variables using excel data to solve the equations, but defining the cell array size i am getting the error.

nX = size(X,1 );
Solutions= cell(1, nX);
for S=1:nX
   Xo=(Xs+(R(S)*Xr))/(1+R(S));
   X =((bt*Qo(S)*(1+R(S))*Xo)+(Y*1000*a*V*J*bs))/(bt*((Qo(S)*(1+R(S)))-((V*Y*k*N)/((Kn*1000)+N))+V*kd));
     eqn1=Qo(S)*(1+R(S))*(No(S)-N)-V*((a*J*1000)+((X*k*N)/((Kn*1000)+N)))==0;
      eqn2=(sqrt((Lstar^1.76)+(5.2*(Nstar-Nstar_min)))-(Lstar^0.88))/2.6==jstar^0.88;
      Solutions=vpasolve([eqn1,eqn2],[N,J]);
   temp = struct2cell(Solutions);
   sold= vpa(horzcat(temp{:}));

5 个评论
显示 3更早的评论隐藏 3更早的评论

KSSV 2021-2-8

sunitha commented: i have defined the variable X . The error is showing in the while defining the cell array size.Actually i have defined the variable X in the equation

KSSV 2021-2-8

在 MATLAB Online 中打开

X should be defined before the line:

nX = size(X,1 );

请先登录，再进行评论。

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

回答（1 个）

Walter Roberson 2021-2-8

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/739097-define-the-cell-array-size-for-excel-data#answer_617612

在 MATLAB Online 中打开

nX = length(R);
Solutions = cell(1, nX);
sold = zeros(nX,2);
for S=1:nX
   Xo=(Xs+(R(S)*Xr))/(1+R(S));
   X =((bt*Qo(S)*(1+R(S))*Xo)+(Y*1000*a*V*J*bs))/(bt*((Qo(S)*(1+R(S)))-((V*Y*k*N)/((Kn*1000)+N))+V*kd));
   eqn1=Qo(S)*(1+R(S))*(No(S)-N)-V*((a*J*1000)+((X*k*N)/((Kn*1000)+N)))==0;
   eqn2=(sqrt((Lstar^1.76)+(5.2*(Nstar-Nstar_min)))-(Lstar^0.88))/2.6==jstar^0.88;
   Solutions{S} = vpasolve([eqn1,eqn2],[N,J]);
   temp = struct2cell(Solutions{S});
   sold(S,:) = double(horzcat(temp{:}));
end