Error when using fprintf to show a string
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentare
Antworten (1)
Sarah Wait Zaranek
am 23 Mär. 2011
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 Kommentare
Siehe auch
Kategorien
Mehr zu Characters and Strings finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!