compare of data from an excel file to the data in a loop
1 次查看(过去 30 天)
显示 更早的评论
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 个评论
Bob Thompson
2018-11-28
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.
回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!