I have to automatically update excel after each run so that numbers are stored in different cells in number plate extraction. Can anyone help?

Question

Jerry Paul 2017-5-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/338559-i-have-to-automatically-update-excel-after-each-run-so-that-numbers-are-stored-in-different-cells-in

回答： yanqi liu 2021-9-26

I have to automatically update excel database after each run so that numbers are stored in different cells in number plate extraction. ie., each time I run the code with different number plate images the values extracted should be stored in a different cell without affecting the previous one.

This is the code:

clc; close all; clear all; %................................. f=imread('A4.jpg'); f=imresize(f,[600 NaN]); %%image loading unit imshow(f); g=rgb2gray(f); g=medfilt2(g,[3 3]); %********************************** conc=strel('disk',1); gi=imdilate(g,conc); ge=imerode(g,conc); %%%% morphological image processing gdiff=imsubtract(gi,ge); gdiff=mat2gray(gdiff); gdiff=conv2(gdiff,[1 1;1 1]); gdiff=imadjust(gdiff,[0.5 0.7],[0 1],.1); B=logical(gdiff); [a1 b1]=size(B); figure(2) imshow(B) er=imerode(B,strel('line',100,0)); figure(3) imshow(er) out1=imsubtract(B,er); F=imfill(out1,'holes'); %%%filling the object H=bwmorph(F,'thin',1); H=imerode(H,strel('line',3,90)); figure(4) imshow(H) %% final=bwareaopen(H,floor((a1/15)*(b1/15))); final(1:floor(.9*a1),1:2)=1; final(a1:-1:(a1-20),b1:-1:(b1-2))=1; yyy=template(2); figure(5) imshow(final) Iprops=regionprops(final,'BoundingBox','Image'); hold on for n=1:size(Iprops,1) rectangle('Position',Iprops(n).BoundingBox,'EdgeColor','g','LineWidth',2); end hold off NR=cat(1,Iprops.BoundingBox); %%Data storage section [r ttb]=connn(NR);

if ~isempty(r)

    xlow=floor(min(reshape(ttb(:,1),1,[])));
    xhigh=ceil(max(reshape(ttb(:,1),1,[])));
    xadd=ceil(ttb(size(ttb,1),3));
    ylow=floor(min(reshape(ttb(:,2),1,[])));    %%%%%area selection
    yadd=ceil(max(reshape(ttb(:,4),1,[])));
    final1=H(ylow:(ylow+yadd+(floor(max(reshape(ttb(:,2),1,[])))-ylow)),xlow:(xhigh+xadd));
    [a2 b2]=size(final1);
    final1=bwareaopen(final1,floor((a2/20)*(b2/20)));
    figure(6)
    imshow(final1)
    Iprops1=regionprops(final1,'BoundingBox','Image');
    NR3=cat(1,Iprops1.BoundingBox);
    I1={Iprops1.Image};
    carnum=[];
    if (size(NR3,1)>size(ttb,1))
        [r2 to]=connn2(NR3);
        for i=1:size(Iprops1,1)
            ff=find(i==r2);
            if ~isempty(ff)
                N1=I1{1,i};
                letter=readLetter(N1,2);
            else
                N1=I1{1,i};
                letter=readLetter(N1,1);
            end
            if ~isempty(letter)
                carnum=[carnum letter];
            end
        end
    else
        for i=1:size(Iprops1,1)
            N1=I1{1,i};
            letter=readLetter(N1,1);
            carnum=[carnum letter];
        end
    end
    fid1 = fopen('Number.xls', 'wt');
    fprintf(fid1,'%s',carnum);
    fclose(fid1);
    winopen('Number.xls')

Can anyone help?

Thank you!

2 个评论
显示无隐藏无

Guillaume 2017-5-3

编辑：Guillaume 2017-5-3

"automatically update excel database"

Excel is not a database! Now, if you actually were using a proper database inserting new rows in the database would be trivial.

Appending data to an excel sheet is not as easy.

peter ernesto zuarez buendia 2021-9-24

Yes

请先登录，再进行评论。

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

Answer 1

Sulaymon Eshkabilov 2021-9-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/338559-i-have-to-automatically-update-excel-after-each-run-so-that-numbers-are-stored-in-different-cells-in#answer_794529

Probably, it is worth to try writematrix() to write your data in '.txt' or '.csv' or '.xls' with 'append' option on.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

yanqi liu 2021-9-26

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/338559-i-have-to-automatically-update-excel-after-each-run-so-that-numbers-are-stored-in-different-cells-in#answer_795134

sir, we can see

"

each time I run the code with different number plate images the values extracted should be stored in a different cell without affecting the previous one.

"

so, I think you can use

A = xlsread('your excel file');

A{end+1,1} = carnum;

xlswrite('your excel file', A);