What kind of magic do I need to get python to talk to Excel xlsm file?

Peter Otten __peter__ at web.de
Tue Sep 1 06:12:53 EDT 2020


Steve wrote:

> Glutton for punishment, I am looking into designing another .py program. 
> I would like to pull two columns of information from Excel but the more I
> look
> into coding on the 'net, the more confusing it looks.  I don't understand
> what I need to import or install to get the link.

openpyxl should be fine to to extract data from an Excel table:

https://openpyxl.readthedocs.io/en/stable/usage.html

Of course this cannot magically turn Python into Basic, and there are 
probably other limitations.



More information about the Python-list mailing list