Yes. The logic would be something like below,
1. Read row 1 from one.xls in C Drive
2. With this row 1 data query [ Select * From Sheetname
] the one.xls on D drive and check if that value exists if it does pass it else fail.
However, there are other ways to do it as well. You may google for Excel comparision for sample codes.
If the data is large then i recommend you script it in perl using the Hash table. It is efficient and handles the value and key pair for large data very cohesively.
1. Read row 1 from one.xls in C Drive
2. With this row 1 data query [ Select * From Sheetname
] the one.xls on D drive and check if that value exists if it does pass it else fail.
However, there are other ways to do it as well. You may google for Excel comparision for sample codes.
If the data is large then i recommend you script it in perl using the Hash table. It is efficient and handles the value and key pair for large data very cohesively.
Basanth
Give a fish to a man and you feed him for a day..Teach a man how to fish and you feed him for life.
Give a fish to a man and you feed him for a day..Teach a man how to fish and you feed him for life.
