필터 지우기
필터 지우기

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 CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by