How to compare two excels for matches and differences row by row in Matlab?
20 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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
0 commentaires
Réponses (1)
Guillaume
le 11 Mar 2020
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).
0 commentaires
Voir également
Catégories
En savoir plus sur Data Import from MATLAB dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!