working with excel in MATLAB script

11 次查看(过去 30 天)
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
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 个)

类别

Help CenterFile Exchange 中查找有关 Data Import from MATLAB 的更多信息

产品


版本

R2016a

Community Treasure Hunt

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

Start Hunting!

Translated by