Error when using fprintf to show a string

Question

VQ 2011-3-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/3809-error-when-using-fprintf-to-show-a-string

Hi, I want to display a cell from Excel that contains a string and I use fprintf. Here's the code:

function [] = readExcel(a)

a=input('Type the name of the .xls file:');

[num,p_hex]=xlsread(a,'A2:A100');

[distance, string]=xlsread(a,'B2:B2');

[numeric, los]=xlsread(a,'C2:C2');

c=hex2dec(p_hex);

mn=mean(c);

fprintf('\n\nThe mean value is: %.3f\n',mn);

fprintf('Distance: %.2f m.\n',distance);

fprintf('Line of sight?:%s',los);

end

When I run the code, I get this error:

??? Error using ==> fprintf Function is not defined for 'cell' inputs.

Error in ==> fprintf('Line of sight?:%s',los);

What's the problem?,Can anybody help me?

Thanks.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Sarah Wait Zaranek 2011-3-23

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/3809-error-when-using-fprintf-to-show-a-string#answer_5478

The output when you call XLSREAD with two output variables returns the second output is the text fields in cell array. This means that los is a cell - if you index into the cell using curly braces (i.e. {}) you will get the contents of that cell, or the string.