the loop for comparing two excels row by row

1 次查看(过去 30 天)
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 个)

标签

Community Treasure Hunt

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

Start Hunting!

Translated by