Re: Comparing two excel workbook and copy the values if the cell are match

Hi naga7667, welcome to the Monastery!

What have you tried and how did it fail?

Do you want the program to operate directly on the XLS files, or do you work with exported CSVs?

Have you tried searching this site for similar questions?

($q=q:Sq=~/;[c](.)(.)/;chr(-||-|5+lengthSq)`"S|oS2"`map{chr |+ord
}map{substrSq`S_+|`|}3E|-|`7**2-3:)=~y+S|`+$1,++print+eval$q,q,a,
[download]

Comment on Re: Comparing two excel workbook and copy the values if the cell are match Download Code

Replies are listed 'Best First'.
Re^2: Comparing two excel workbook and copy the values if the cell are match by naga7667 (Initiate) on Sep 26, 2017 at 16:53 UTC
I tried to copy columns to array but dint work out...also I should use only Win32:OLE Its a two Excelfiles. I am able to store the values in array but cannot compare with another array	[reply]
Re^3: Comparing two excel workbook and copy the values if the cell are match by poj (Abbot) on Sep 26, 2017 at 17:58 UTC
I am able to store the values in array Post the code you have for that part. poj	[reply]