How to compare two excels for matches and differences row by row in Matlab?

In first excel, i have a spreadsheet(100x100). In second one, i have a spreadsheet which is only 1 row x 100 colums. I would like to compare second excel file with first excel for matches row by row. I need to know which row from first excel matches with row from second excel. Thank you

Answer 1

[Guillaume]

allrows = readmatrix('your1stexcelfile');  %readmatrix requires R2019a or later
singlerow = readmatrix('your2ndexcelfile'); 

isthesinglerow = ismember(allrows, singlerow, 'rows');

isthesinglerow will be a logical array where a 1 indicates that the corresponding row of allrows matches singlerow. If you want the index of these rows use find(isthesinglerow).