Need to compare two excel and extract the mismatch data

1 回表示 (過去 30 日間)
Pratik Yadav
Pratik Yadav 2020 年 3 月 9 日
コメント済み: Pratik Yadav 2020 年 3 月 9 日
I have excel Conatant_Sheet1 in that I have two coloumns like signal name and the conatant value.
I have excel 2 name Constant_sheet2 in that again the same data but count is mismatched.
Suppose if in sheet1 we have 10 conatants then there will be 8 conatnts in sheet2 I need to comapre these names along with the values and extarct the names of the signals which are having the differences.
I have attached two sample excel sheets here. Expected results will be like the mismatched data
as Conatant You is added in the sheet2 and value of conatant Barak_obama is chnaged so this is again one mismatch
I want this two misamtched signal names along with their values in the output( whereever in new excel or in matlab variable ..any possible ways)
Mismatched data :
Barak_Obama 4
You 5
Thanks in Advance .... !!!!
  3 件のコメント
Alex Mcaulley
Alex Mcaulley 2020 年 3 月 9 日
setxor could be another option. As @darova says show us your code and your specific issues to obtain better answers
Pratik Yadav
Pratik Yadav 2020 年 3 月 9 日
I didnt prepared any code. But I serached that it can be done with the help of spreadsheet comapre. So can we trigger spreadsheet compare software through matlab,just like we can trigger excel though matlab

サインインしてコメントする。

回答 (0 件)

カテゴリ

Help Center および File ExchangeSpreadsheets についてさらに検索

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by