Python Forum

Full Version: Python Packages for Excel
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi,

Which packages are by default included in Python 3.7 to interact with Excel?

Imran Bhatti
Python standard library does not have modules that interact with Excel (xl*/xls*) files. You need to install third party packages.

There are distributions like Anaconda that come with some third-party packages pre-installed. Actually you still need to install external packages yourself.
Research these modules:
* cvs
* pyexcel
* xlsxwriter
* xlrd
* xlwt
* openpyxl

phil
thanks to all.

Will research phil.

little bit feeling I will find what I am after.
Also to add to list that @pcsailor posted.
Pandas is good,and with Jupyter Notebook get a look that similar to Excel.
Common Excel Tasks Demonstrated in Pandas
Python Excel Tutorial: The Definitive Guide
also xlwings
Thanks for the list. But one thing is still unanswered
Which items of these list are shipped with Python 3.7. so that I have not to install them separately?
Did you read my first post:
(Oct-01-2018, 09:20 AM)buran Wrote: [ -> ]Python standard library does not have modules that interact with Excel (xl*/xls*) files. You need to install third party packages.

Only csv module is part of Standard library, but it's not for xl*/xls*
Nothing from the standard library interacts with .xlsx/.xls with a Python 3.7 installation.
You need to install 3rd-party modules,
unless .csv is the only type of spreadsheet you need to interact with.
If so, you can use the CSV module installed with Python.
I can see which modules are installed on my Windows machine looking here: C:\Program Files\Python37\Lib.
phil