Error when using fprintf to show a string
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponses (1)
Sarah Wait Zaranek
le 23 Mar 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 commentaires
Voir également
Catégories
En savoir plus sur Characters and Strings dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!