error when reading from xls sheet

Question

Ayda 2011-10-31

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/19937-error-when-reading-from-xls-sheet

关闭： MATLAB Answer Bot 2021-8-20

Good evening\morning

I have a system of equations and i expressed them in matrix form

R=[ R(3)+R(5)+R(8) , -R(5) , 0 , -R(3);
    -R(5), R(1)+R(4)+R(5)+R(7) , -R(4), 0;
    0, -R(4) , R(2)+R(4)+R(6) , -R(6);
    -R(3) , 0 , -R(6) , R(3)+R(6)+R(9)];
V= [V(1);0;0;V(2)];

I've to do a matrix division and some other things But when I read the voltages values from xls file as

it read it Matrix V (in Volts)

Also when it try to enter the value from the terminal it read it as zero

fid= fopen('mesh.txt','w');
% R=input('inter resistor value in kilo ohms, [R1...R9]= ');
R=xlsread('test');
% V=input('inter voltage value in volt, [V1 V2]= ');
V=xlsread('v');
R=[ R(3)+R(5)+R(8) , -R(5) , 0 , -R(3);
      -R(5), R(1)+R(4)+R(5)+R(7) , -R(4), 0;
      0, -R(4) , R(2)+R(4)+R(6) , -R(6);
      -R(3) , 0 , -R(6) , R(3)+R(6)+R(9)];
V= [V(1);0;0;V(2)];
fprintf(fid,'Matrix R (in Kohms)\n\n');
fprintf(fid,'\t%.1f\t\t %.1f\t\t %.1f\t\t %.1f\t\n\n',R);
fprintf(fid,'Matrix V (in Volts)\n\n');
fprintf(fid,'%.1f\n %.1f\n %.1f\n %.1f\n\n',V);
I=R\V;
fprintf(fid,'Mesh Currents I (in mAmber)\n\n');
fprintf(fid,'%.4f\n %.4f\n %.4f\n %.4f\n\n',I);
inverse= inv(R);
fprintf(fid,'Inverse of R (in Kohms)\n\n');
fprintf(fid,'%.4f\t %.4f\t %.4f\t %.4f\t\n\n',inverse);
I=invers\V;
fprintf(fid,'Mesh Currents I (in mAmber)\n\n');
fprintf(fid,'%.4f\n %.4f\n %.4f\n %.4f\n',I);
fclose(fid);

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

bym 2011-10-31

I think you have a number of typographical errors (typos) in your code; plus formatting it using the {}Code button would help readability and increase the probability someone would provide the answer you seek

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