compare of data from an excel file to the data in a loop

Hello,
I have an excel file of 3 columns and 200 rows, I am comparing the result data from a loop to each of the data of the excel file to see their difference, lets say:
I need to read cell A2 for the for the first result of loop and if it A2 is larger than the result go to B2, and A3 for second result and so on.
Can you guide me how to do that?

3 Comments

I would suggest you toread the whole excel file and then compare the data
so can you please let me know how I can for example compare the B3 cell data with the second data of my loop?
If you load the entire array from the excel file into Matlab then comparing is just a matter of indexing. You can do this for each cell individually if you place the comparison within the loop, and then make the indexing be reactive to the change in loop index.

Sign in to comment.

Answers (0)

Asked:

on 28 Nov 2018

Commented:

on 28 Nov 2018

Community Treasure Hunt

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

Start Hunting!