• Home
 · 
• Complete Applications
 · 
• ExcelCompare

ExcelCompare

This code will load 2 excel files into grid controls and compare the contents and show the differences both by highlighting the cells in grid controls and also by listing the different cells in a third grid.

Inputs
select each file to compare (I attached 2 different excel files as an example).

Assumes
The Original example for loading excel into a grid control is at : http://www.Planet-Source-Code.com/vb/scripts/ShowCode.asp?txtCodeId=61399&lngWId=1 and was submitted by Cristiano Couto. I modified it to open 2 excel files and compare each cell.

Returns
shows the differences

Side Effects
less aggravation when sorting through the many versions of the same excel file.

API Declarations
see code

Rate ExcelCompare

• 1
• 2
• 3
• 4
• 5

(8(8 Vote))

Download ExcelCompare