How to compare the excel data with data in table(Database)?I have one scenario.
1) Uploading of excel. Excel having 10 row with 10 column
I have attached one excel for your reference.
If i upload it will get inserted into table named ABC in backend with one ID(Say 1) generated for that 10 rows.
2) If i upload the same excel again, it is getting inserted in backend by generating the ID no. 2.
When i upload the excel, I want to compare the data in excel with the data in database based on ID. If the database having the same data as that of second upload file it should show message as "Already exist". How can we achieve this. It should give message if the all
the row and all the data in the cell matches.
THANKS IN ADVANCE