working with excel in MATLAB script
显示 更早的评论
Hi every one.
I have an problem with my excel in matlab, if you can, plearse guide me.
how can i compare the numerical cells which has zero value and non-zero value, then the MATLAB calculate the number of difference in each row. and at last show the column thah has zero value.
thanks.
采纳的回答
Image Analyst
2020-1-4
Did you try xlsread() to read in the workbook? You say you want to "compare the numerical cells" but don't say what compare means to you.
Then, after that comparison (whatever that is), you say you want to "calculate the number of difference". To find out if one variable is different from another, you can use isequal() to compare the whole variable (matrix), or use ~= to compare each element individually, like
differenceMap = matrix1 ~= matrix2; % A binary map of where they are different.
Then to count the number of differences you can sum that map
numberOfDifferences = sum(differenceMap)
更多回答（0 个）
类别
在 帮助中心 和 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!
Translated by 
