Cross reference from 2 excel files in Matlab
显示 更早的评论
Hello,
I have two excel documents which I have imported to matlab with xlsread.
Now my task is to take a destination code from file 1 and match it with a destination name from file 2. (screenshots of the two different files)
I hope someone is able to help me with some pointers on how to do this.
Thank you in advance - Emil
回答（1 个）
Nikhil Sreekumar
2017-4-25
Hi there,
What exactly is it that you are meaning on saying match the two columns?
- Comparing each row element in one with each row element in another?
- Comparing corresponding row elements?
- Comparing columns of different size?
If you doing xlsread and taking the raw data, then you can do something like this to do a corresponding element-wise comparison:
Case - Check if both columns same
[~, ~, raw1] = xlsread('data1.xlsx');
Destination1 = {raw1{:, 1}}; % column 1
[~, ~, raw2] = xlsread('data2.xlsx');
Destination2 = {raw2{:, 1}}; % column 1
isequal(Destination1, Destination2);
You can also check ismember function
Thanks
Nikhil
类别
在 帮助中心 和 File Exchange 中查找有关 Data Type Identification 的更多信息
产品
2017-4-22
2017-4-25
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
