different excel file comparisons
18 ビュー (過去 30 日間)
古いコメントを表示
Hello, I have two excel files,
First excel file as shown below

and second excel file as shown below.

I want to compare these excel files values but ı have a problem. As you seen in the first column the order of the names are not same. How can I compare these two excel file among the same names.I will print the results on the adjacent column after the comparison.
0 件のコメント
回答 (1 件)
KSSV
2021 年 4 月 19 日
T1 = readtable(file1) ;
T2 = readtable(file2) ;
idx = ismember(T1.names, T2.names)
参考
カテゴリ
Help Center および File Exchange で Data Import from MATLAB についてさらに検索
製品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!