Comparing two .xls files ?

[huytonscouser]

What's the best way to compare differences between 2 .xls files ?
i.e. yesterday and today

Both files have same columns headings/data

Of course the files have no real relationship, via primary/foreign keys.

i could create a key via a checkeum for each column, but will
wait to see if anyone has experience comparing/reporting on
2 .xls datasources.

Thanks

 

[CRCRCR]

Why don't you just do this in Excel?

How many sheets are you comparing? This has a bearing on the problem.

If you paste in one sheet1 into the other workbook's sheet2, then in sheet3,

you should find , (ignoring exact syntax) the formula

sheet1!A1 = sheet2!A2

equaling true.

k.

 

[huytonscouser]

Thanks for the suggestion. It is only 2 sheets. Yesterday.sheet1 and Today.sheet1.

That would work as a 1 off, but we need to generate roll on and subsequent reports, and also automate delivery of the reports.

So it needs to done via a crystal report. Was just asking about the best way to generate a "differences" report for 2 .xls worksheets as the datasources.

Thanks