Python Packages for Excel

[ImranBhatti]

Hi,

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

Imran Bhatti

[buran]

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.

[pcsailor]

Research these modules:
* cvs
* pyexcel
* xlsxwriter
* xlrd
* xlwt
* openpyxl

phil

[ImranBhatti]

thanks to all.

Will research phil.

little bit feeling I will find what I am after.

[snippsat]

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

[buran]

also xlwings

[ImranBhatti]

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?

[buran]

Did you read my first post:

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*

[pcsailor]

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