Excel文件比较 [英] Excel file comparison

问题描述

你好，
我正在为老板写一个解决方案，但我为其中的解决方案而苦恼..解释不清.

我有2个excell工作表(file1.xls，file2.xls).
这两个文件都包含2列，第一个列包含variableNames，第二个列包含value(data)(numeric).
两个文件的第一个列完全相同.

现在，我想编写一个比较两个文件的脚本，然后将所有差异写入第三个文件(file3.xls).
我不知怎地想出一种方法来实现这一目标.

最好的事情是我可以在新的excell工作表(compare.xls)中实现的代码，但它也可能是visualStudio脚本或vb6或其他任何vb(ASP除外).

这是文件外观的示例:

http://www.catteryyelan.nl/images/question.png [

Hello,
im writing a solution for my boss, but i am struggled with a piece of the solution.. ill explain.

i have 2 excell sheets (file1.xls, file2.xls).
both files contain 2 columns, the first collumn contains variableNames, the 2nd collumn contains the value(data)(numeric).
the 1st collumns of the 2 files are exactly the same.

now i want to write a script that compares the 2 files, then write all the differences into a 3rd file (file3.xls).
somehow i cant imagine a way how to accomplish this.

the nicest thing is a code that i can implement in a new excell sheet(compare.xls) but it may also be a visualStudio script or vb6 or anything else vb (except ASP).

here is an example of how the files look:

http://www.catteryyelan.nl/images/question.png[^]

thnx in advance,
Tommy

推荐答案

请参阅链接 http://www. exceltip.com/st/Compare_two_worksheets_using_VBA_in_Microsoft_Excel/477.html [ ^ ]

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