Error when using fprintf to show a string
1 回表示 (過去 30 日間)
古いコメントを表示
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 件のコメント
回答 (1 件)
Sarah Wait Zaranek
2011 年 3 月 23 日
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.
0 件のコメント
参考
カテゴリ
Help Center および File Exchange で Characters and Strings についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!