how to read specifiied values from xls file?

2 次查看（过去 30 天）
ajay Hiremath
ajay Hiremath 2015-1-30
评论： ajay Hiremath 2015-1-30
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

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

采纳的回答

Hikaru
Hikaru 2015-1-30
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 个评论
ajay Hiremath
ajay Hiremath 2015-1-30
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);

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by