Matlab code i need for below problem

2019 3 25
4 个回答
回答已采纳
更新时间：2019 4 23
3 次查看（30 天）

0 个投票

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

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

 采纳的回答

Walter Roberson
Walter Roberson 2019-3-25

0 个投票

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

12 个评论
显示 10更早的评论 隐藏 10更早的评论

akshatha nayak
akshatha nayak 2019-3-25
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
Walter Roberson 2019-3-25
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
akshatha nayak 2019-3-25
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
Walter Roberson 2019-3-25
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
akshatha nayak 2019-3-25
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
Walter Roberson 2019-3-25
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
akshatha nayak 2019-3-25
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
Walter Roberson 2019-3-25
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
akshatha nayak 2019-3-25
No fingerprint and all taking image from foldrr and then comparing
Walter Roberson
Walter Roberson 2019-3-25
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
akshatha nayak 2019-3-31
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
Walter Roberson 2019-3-31
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?

请先登录，再进行评论。

更多回答（3 个）

akshatha nayak
akshatha nayak 2019-3-25

0 个投票

Now we need to comapre tht inage and store the result value
akshatha nayak
akshatha nayak 2019-3-25

0 个投票

Selectibg image is working properly but compating and storing the result in folderis difficult
akshatha nayak
akshatha nayak 2019-4-1

0 个投票

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.

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

akshatha nayak
akshatha nayak 2019-4-23
How to take real world image of person eye and store it in mysql database and use that image for comparing with other image ?

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by