比较并找到添加的行 [英] Compare and find added rows

问题描述

嘿所有， 

Hey all, 

我正在寻找一种方法来比较两个工作表并找到插入或删除的行。

I'm looking for a way to compare two worksheets and find inserted or deleted rows.

工作簿已保存（所以我无法捕获ws_change等）并且没有跟踪。

the workbook has been saved (so I can not catch with ws_change or so) and there is not tracking.

此处的问题是，也可能在一个或两个中添加/删除列工作表。这很难。

the problem here is that also columns might be added/deleted in one or both worksheets. This makes it difficult.

所以我认为基本上需要一个算法吗？

so basically an algorithme is required for this, I think?

任何想法：）

问候

Arie

推荐答案

简短版本：如果您能够以与这两张纸的实际情况完全匹配的方式写出识别"已插入"和"已删除"的标准，那么您应该可以编写一些内容来查找这些内容特定情况。

Short version: If you can write out the criteria for identifying 'inserted' and 'deleted' in a way that exactly matches the reality of these two sheets, you should then be able to code something to find these specific cases.

问题：是否可以在两张纸上添加或删除行或列？换句话说，两个工作表都以一个标题为"ThisBigThing"的列开头，并且从两个工作表中删除了该列。如果发生这种情况，则无法对解决方案进行编码。插入的
相同。

Question: Is it possible for a row or column to be added or deleted from both sheets? In other words, both sheets started with a column headed 'ThisBigThing' and this column was deleted from both sheets. If this can happen, you can't code a solution. Same thing for inserts.

为了使其正常工作，您需要一些您知道正确的裁判值。

In order for this to work, you need some referee value you know to be right.

这篇关于比较并找到添加的行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！