Import excel, Compare Vectors, and output results including strings

1 次查看（过去 30 天）

Zekeftw 2016-3-31

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/276450-import-excel-compare-vectors-and-output-results-including-strings

评论： Jeevan Joishi 2016-4-6

Hi,

I'm trying to import two excel spreadsheets (attached) then compare the "Amount" column on Expenses.xlsx to Total_Fee, Fee1, and Fee2 on database.xlsx.

Finally, I would like to output all the values (including the corresponding strings) that are missing from columns Total_Fee, Fee1, and Fee2.

For example, the output would be

I'm having trouble reading the excel file with [num,txt,raw] = xlsread(_). I'm getting a lot of NaN values. I was thinking of using something like out = Amount(ismember(Amount,[Total_Fee;Fee1;Fee2]) == 0) to help me do the comparison and output but I'm now sure what syntax to use to tell it what columns to look it.

Thank you.