How to compare two different excel sheets specific columns for like values

15 次查看（过去 30 天）

Tyler Ginet 2022-1-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1633640-how-to-compare-two-different-excel-sheets-specific-columns-for-like-values

评论： Tyler Ginet 2022-1-24

I am trying to compare two excel files, specifically a column in each. The cells contain numbers and letters and arent in order. I am trying to update a condensed list to ensure that it has the master's values. It has been a few years since ive used MATLAB. I tried using the setdiff function to compare arrays from each with no luck. TIA!

7 个评论
显示 5更早的评论隐藏 5更早的评论

Voss 2022-1-21

在 MATLAB Online 中打开

I thought you want to find out which values in the full list aren't in the condensed list:

C = A(~ismember(A,B)); % Full list elements not in Condensed list

rtather than which values in the condensed list aren't in the full list:

D = B(~ismember(B,A)); % Condensed list elements not in Full list

Tyler Ginet 2022-1-24

I tried both C and D. Unfortunately that didnt work. Thank you though!

请先登录，再进行评论。

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

回答（1 个）

Ive J 2022-1-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1633640-how-to-compare-two-different-excel-sheets-specific-columns-for-like-values#answer_879440

在 MATLAB Online 中打开

xlsread is deprecated, avoid it.

fullTab = readtable('File1.xlsx');
denseTab = readtable('File2.xlsx'); 
[idxFull, idxDense] = ismember(fullTab.(13), denseTab.(3)); 
idxDense(idxDense < 1) = [];
fullCol13Unique = A.(13)(~idxFull);