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

Question

Yera Yera 2020-3-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/510297-how-to-compare-two-excels-for-matches-and-differences-row-by-row-in-matlab

回答： Guillaume 2020-3-11

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Guillaume 2020-3-11

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/510297-how-to-compare-two-excels-for-matches-and-differences-row-by-row-in-matlab#answer_419618

在 MATLAB Online 中打开

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).