How to append data in excel file ? why my program given below is not working ?
1 回表示 (過去 30 日間)
古いコメントを表示
Hi friends, I want to append the data generated by some calculations to the existing excel file. In the program given below, i'm generating ASCII values and converting them to character. But it is not giving the intended result.And it is not giving any error also. Please assist me. Thankq...
______________________________________________________________
a=imread('ct1.jpg');
imshow(a);
n=4
[x y]=ginput(n);
num=65;
for i=1:n
b=a;
c=imcrop(b,[x(i) y(i) 30 30]);
figure,imshow(c);
d=sum(sum(c));
d=d'
%imwrite(a,'sample.tif');
%fname=strcat('A',num2str(i))
num=num+1
s = xlswrite('sample.xls', d,1,'char(num)');
end
_______________________________________________________________
0 件のコメント
回答 (1 件)
Desiree
2011 年 8 月 25 日
Function CHAR will not help in calculating the Excel ranges as those are in the A1 notation. You can find user-contributed utilities in MATLAB Centrals File Exchange though which can manage the conversion of numbers to the Excel range notation for you, f.ex.:
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!