Is there a freeware that is portable (do not require to be install) and can compare two excel sheets that come from two different excel file. It will highlight the different by showing which cells is different)
Example:
There are two sheets (named Sheet1
and Sheet2
) in the first excel file (named Excel1.xls
)
There is this second excel file (named Excel2.xls
) that contain one sheets (named SheetZ
)
Inside Sheet1
, there is data occupy on the first two row and two column.
Inside Sheet2
, there is no data.
Inside SheetZ
, there is data occupy on the first 3 rows and 3 column. (Only the 1st cell have the same data as the 1st cell in Sheet1
)
So, when I do a compare of the excel sheets from the two excel files, the software will generate a report as follows:
Data Difference
Excel1.xls
(1st Sheet)Sheet1
B1Sheet1
C1Sheet1
A2Sheet1
B2Sheet1
C2Sheet1
A3Sheet1
B3Sheet1
C3
Excel2.xls
(1st Sheet)SheetZ
B1SheetZ
C1SheetZ
A2SheetZ
B2SheetZ
C2SheetZ
A3SheetZ
B3SheetZ
C3
Same Data
- 1st Sheet A1
It may not be the exact report as shown above, as long as it can compare excel sheets from two different excel file.