Matlab code i need for below problem

I want to check whether the data that is present in sheet 1 of excel is same as sheet 2 of excel of same file name tht is testdata1.xls can any 1 help me to solve this problem

Answer 1

[Walter Roberson]

filename = 'testdata1.xls';
T1 = readtable(filename, 'sheet', 1);
T2 = readtable(filename, 'sheet', 2);
if isequal(T1, T2)
    disp('Sheet 1 is the same as sheet 2')
else
    disp('Sheet 1 is not the same as sheet 2')
end

[akshatha nayak]

But in sheet 1 i have id. Name and branch And from gui i will enter id that need to checked If that id what i have entered in gui is present in sheet1 then it shuld be stored in sheet2

[Walter Roberson]

What does that have to do with checking to see if what is in sheet 1 is the same as what is stored in sheet 2?

If the user asks about the same id twice, then should the id be stored twice in sheet 2?

[akshatha nayak]

It is like authentication if the user with his id had already register then he can sign in to that page Now sheet1 is registration Sheet 2 is login page

[Walter Roberson]

This question is getting more and more confusing.

Suppose the user enters a particular ID, such as hank_plym . Then what should be looked for in sheet 1? If it is not found, what should be done? If it is found, then what should be looked for in sheet 2, or what should be written into sheet 2 (and where in sheet 2 should it be written) ?

[akshatha nayak]

Whn user enter hank_plym thn hank_plym is looked into sheet1 if it us not found then shuld display error msg saying tht not registered if it is found then should store in sheet2

[Walter Roberson]

Okay, where should it it store it in sheet 2? First column, next available location? So if the same id is requested, there would be multiple entries with the same ID? Should any other information be recorded? Do you want to search the second sheet to see if the ID is already there and if so then update a "last login" field for the ID ?

[akshatha nayak]

Herr 2 push button is therr capture image 1 and capture image 2 Take that 2 image and whn i press verify it shuld compare 2 images and retrun wherther it compare or not

[Walter Roberson]

What does this have to do with excel ?? You need to take two pictures with the camera and compare the two pictures (for some meaning of compare)

... And why do I suspect that the next time around, you will tell me that the images have to do with fingerprints, that what you are really trying to do is read in a fingerprint and compare it to a database of fingerprints and see if it exists ?

[akshatha nayak]

No fingerprint and all taking image from foldrr and then comparing

[Walter Roberson]

If the images are to be taken from a folder, then why does the GUI talk about "capture" of the image instead of being a button to "select" an image, with the button using uigetfile() to permit the user to choose an image file ?

[akshatha nayak]

Image is not taken from folder i need to capture image and then exctarct oly the eyr portion and then we use that eye portion for comparing purposes if u know the code for this pls help us

[Walter Roberson]

You said above https://www.mathworks.com/matlabcentral/answers/452094-matlab-code-i-need-for-below-problem#comment_685311 that

"all taking image from foldrr and then comparing"

so you told us that the images are being taken from a folder, not being captured.

In any case, if you take an eye image of the user, and you need to compare it to stored eye images, then what are you using Excel for?

Answer 2

[akshatha nayak]

Now we need to comapre tht inage and store the result value

Answer 3

[akshatha nayak]

Selectibg image is working properly but compating and storing the result in folderis difficult

[akshatha nayak]

Do u know to make datbase connection in matlab by usibg sql

Answer 4

[akshatha nayak]

That was other projects Now we are doing new project of capturing real world image of person and then comparing it Herr we are using sql database not that excel thing.

[akshatha nayak]

How to take real world image of person eye and store it in mysql database and use that image for comparing with other image ?