how to read specifiied values from xls file?
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
0 个评论
采纳的回答
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.
更多回答(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!