Python Forum
Python Packages for Excel - Printable Version

+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: Data Science (https://python-forum.io/forum-44.html)
+--- Thread: Python Packages for Excel (/thread-13159.html)



Python Packages for Excel - ImranBhatti - Oct-01-2018

Hi,

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

Imran Bhatti


RE: Python Packages for Excel - buran - Oct-01-2018

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.


RE: Python Packages for Excel - pcsailor - Oct-01-2018

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

phil


RE: Python Packages for Excel - ImranBhatti - Oct-01-2018

thanks to all.

Will research phil.

little bit feeling I will find what I am after.


RE: Python Packages for Excel - snippsat - Oct-01-2018

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


RE: Python Packages for Excel - buran - Oct-01-2018

also xlwings


RE: Python Packages for Excel - ImranBhatti - Oct-02-2018

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?


RE: Python Packages for Excel - buran - Oct-02-2018

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*


RE: Python Packages for Excel - pcsailor - Oct-03-2018

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