[Python] Get value from Excel files on network drive from a fixed cell reference using Python

I have Excel files stored on a network share drive that has a value in a specific cell e.g. K35. The filenames are based on a value in a current Excel file on my local drive. I want to extract the value from the shared file in cell K35 and place it in my local file for each line that corresponds to the file on the shared drive. The file name can be derived from the first column in my local Excel file.

Can this be done using Python (Openpyxl on Pandas)?

Continue reading...