working with excel in MATLAB code

Hi every one,

I am working on an excel file that I attach it, and I want to compare two columns of that file and check if the value of them and if they are not equals, return 1. The excel file is not regular and number of rows are variable in each section and some empty cells are between the two sections. Now I want to know that how can I do this?

Thanks so much.

[Walter Roberson]

Excel Reader warns me that the sheet has formulas with circular references.

[amirmasoud kochakzadeh]

Hi i fix it again

Answer 1

[Walter Roberson]

Col1 == Col2 | (isnan(Col1) & isnan(Col2))

[amirmasoud kochakzadeh]

thanks alot Sr.

but aother qustion how can i change the double form matrix to table form

[Walter Roberson]

array2table

Or these days it often makes sense to use readtable() instead of xlsread()

Answer 2

[amirmasoud kochakzadeh]

thanks alot