Python Forum
Python Packages for Excel
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Python Packages for Excel
#1
Hi,

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

Imran Bhatti
Reply
#2
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.
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Reply
#3
Research these modules:
* cvs
* pyexcel
* xlsxwriter
* xlrd
* xlwt
* openpyxl

phil
Reply
#4
thanks to all.

Will research phil.

little bit feeling I will find what I am after.
Reply
#5
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
Reply
#6
also xlwings
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Reply
#7
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?
Reply
#8
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*
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Reply
#9
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
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Use Python Packages to Increment a Column(not a row) ricmacharia 0 1,808 Jun-10-2019, 09:57 AM
Last Post: ricmacharia
  Security verification of Python "pip" packages? futurity 7 5,295 Aug-23-2017, 04:02 PM
Last Post: Larz60+
  How to use/install different versions of Python packages (Scipy) on the same system? gzb001 3 6,036 Nov-07-2016, 12:56 AM
Last Post: Blue Dog

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020