How can I load 2 excel files, compare specific columns and change bakcground color where cell values differ?
Posted on 2008-06-19
I am developing a WinForm VB 2005 app in which users can load 2 Excel files (let's call them XLS1 and XLS2). Both XLS are loaded into DataGridViews and them I can compare values, columns, etc.
But now I was asked to open 2 XLS files, compare specific columns, row by row and then update the 2nd XLS (XLS2) by changing the background color of cell where values have no match in the first XLS (XLS1).