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

1 回表示 (過去 30 日間)
Shel
Shel 2018 年 11 月 28 日
コメント済み: Bob Thompson 2018 年 11 月 28 日
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 件のコメント
Shel
Shel 2018 年 11 月 28 日
so can you please let me know how I can for example compare the B3 cell data with the second data of my loop?
Bob Thompson
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 ExchangeSpreadsheets についてさらに検索

Community Treasure Hunt

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

Start Hunting!

Translated by