compare of data from an excel file to the data in a loop
1 view (last 30 days)
Show older comments
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
Bob Thompson
on 28 Nov 2018
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.
Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!