how to read specifiied values from xls file?

1 view (last 30 days)
hello all... I want to read lumi and green values from xls file and I used this code...
fid=fopen('newFile11.xls', 'w');
fprintf(fid,'\n%d\t%d\t%d\t%0.3f\t%0.3f\t%0.3f\t%0.3f\t%0.3f\t%0.3f\t%0.3f\t%0.3f\t%0.3f\t%0.3f\t\n', area(i),Length,width,Perimet(i),AspectRat,FormFact(i),Entropy,stats1.Contrast,stats1.Energy,stats1.Homogeneity,stats1.Correlation,green,lumi );
fclose(fid);
%save('leaffff.mat', 'leafname');
% ///////////////////////////////////////////////////////////////////////////
%Load the sample data
datapresent = xlsread('newFile11.xls');
%grn = datapresent(1,12);
%lum = datapresent(1,13);
grn=green;
lum=lumi;
but it is giving.....
File C:\Users\use\Documents\MATLAB\lrc\newFile11.xls not in Microsoft Excel Format. error so how can I do tis.....thank you in advance

Accepted Answer

Hikaru
Hikaru on 30 Jan 2015
This happens when you use fprintf to save a file in .xls extension.
To solve this, use xlswrite to write the data into Excel and then use xlsread to read it.
  1 Comment
ajay Hiremath
ajay Hiremath on 30 Jan 2015
sir I m doing the same thing as you said but m getting this error.... ???error: CAT arguments dimensions are not consistent
the code im using for this is....
filename = 'testdata.xlsx';
A = {'Area','Length','width','perimet','Aspectrat','Form_fact',
'Entropy','Contrast','Energy','homogen','Green','Lumin'; area(i);
Length; width; Perimet(i); AspectRat; FormFact(i); Entropy;
stats1.Contrast; stats1.Energy; stats1.Homogeneity; stats1.Correlation;
green; lumi};
sheet = 1;
xlswrite(filename,A,sheet);

Sign in to comment.

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by