Bottom Page

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
Quote
#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.
Quote
#3
Research these modules:
* cvs
* pyexcel
* xlsxwriter
* xlrd
* xlwt
* openpyxl

phil
Quote
#4
thanks to all.

Will research phil.

little bit feeling I will find what I am after.
Quote
#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
pcsailor likes this post
Quote
#6
also xlwings
pcsailor likes this post
Quote
#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?
Quote
#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*
Quote
#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
Quote

Top Page

Possibly Related Threads...
Thread Author Replies Views Last Post
  Use Python Packages to Increment a Column(not a row) ricmacharia 0 334 Jun-10-2019, 09:57 AM
Last Post: ricmacharia
  Security verification of Python "pip" packages? futurity 7 1,872 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 2,443 Nov-07-2016, 12:56 AM
Last Post: Blue Dog

Forum Jump:


Users browsing this thread: 1 Guest(s)