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