the loop for comparing two excels row by row

1 次查看（过去 30 天）
Tian Tian
Tian Tian 2018-3-2
评论： Tian Tian 2018-3-6
Hi, I am working with a loop to compare excel files in a folder (each excel with the one next to it).The comparison is based on: for each row (Row1) in excel1, ONE row in excel2 is selected when each column number is in a certain range (0.7-1.1 times of that in the same column value in Row1. If there are more than 1 rows selected in excel2, then the row with smallest std (shortest distance to Row1) is selected. Can anyone help me?
  1 个评论
Jan
Jan 2018-3-2
What is the question? The forum can help you, so please post what you have tried so far and ask a specific question.
What is an "Excel file next to it"?

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Sujit Muduli
Sujit Muduli 2018-3-6
Hi Tian,
As I understand from your questions you just want to iterate over the rows for two excel files and make the comparison.You may read the excel data as a table and write a function for your logic. You may find the links below useful,
  1 个评论
Tian Tian
Tian Tian 2018-3-6
Thank you for your answer! Yes I tried reading data as table and it works. My problem has been solved.

请先登录，再进行评论。

更多回答（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!

Translated by