I want to see and edit the values on the excel sheet from Python.

There are two Excel files, and the values included are as follows.

1) Part number, Yes/No, Exemption number
2) Part Number

If the part number in 2) matches the part number in 1) then the file in 2) will contain Yes/No,
I'm trying to fill in the Exemption number in Python.

Work
1)Create a dictionary from the file and save it as a py file.
　If there is a match between the contents of this file and the part number in 2) , please use the Yes/No, Exemption number in 2)
Fill in the designated cell.

Is this possible in the first place?