Oct-01-2018, 08:48 AM
Oct-01-2018, 09:20 AM
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.
There are distributions like Anaconda that come with some third-party packages pre-installed. Actually you still need to install external packages yourself.
Oct-01-2018, 09:26 AM
Research these modules:
* cvs
* pyexcel
* xlsxwriter
* xlrd
* xlwt
* openpyxl
phil
* cvs
* pyexcel
* xlsxwriter
* xlrd
* xlwt
* openpyxl
phil
Oct-01-2018, 11:55 AM
thanks to all.
Will research phil.
little bit feeling I will find what I am after.
Will research phil.
little bit feeling I will find what I am after.
Oct-01-2018, 12:14 PM
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
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
Oct-02-2018, 10:55 AM
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?
Which items of these list are shipped with Python 3.7. so that I have not to install them separately?
Oct-02-2018, 11:09 AM
Did you read my first post:
Only csv module is part of Standard library, but it's not for xl*/xls*
(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*
Oct-03-2018, 04:58 AM
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
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