Python logic with excel file

In the excel file, there are three sheets.
I need to generate the company name and the headlines after searching for the company name from the ‘Final’ sheet and using the company acronym from the Variant Column in the ‘Groupnames’ sheet

Have a look at the openpyxl module:

https://pypi.org/project/openpyxl/

installable with the command:

pip install openpyxl

There’s a little example code on that page, and a link to the
documentation and mailing list.

Cheers,
Cameron Simpson cs@cskk.id.au