How to compare and replace data in an excel table?

Question

PHP

I have 2 excel files.
This file needs to be modified. That is, if the data on the goods differ in the second table, then make changes to the 1st

A. This file is a file with stock balances. That is, the file from which you need to take data and transfer it to the 1st

Tell me how you can automate this process? That is, take the product from the 1st file, find it in the second, and if the data is different, then replace them.
The point here is that the articles are also different. In the 1st file like 02000/15, and in the second file g02000_15
Is it possible to compare and change data from tables using php?

Answer 1

The task is quite solvable using PHPExcel

Answer 2

The task is completely solved through VLOOKUP or MATCH , it is enough to open both documents and when compiling formulas, the data will transfer links to each other when clicking on cells / selecting a table.
You can also use PHP, but why hammer in a nail with a screwdriver?

Answer 3

https://www.youtube.com/watch?v=c_ydkYhcXUI. maybe this is it?