+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: Python for excel (/thread-27916.html)
Python for excel - BuJayBelvin - Jun-27-2020
Can anyone share a reference text specifically geared towards excel users? Not sure it exists. (I have read the openpyxl documentation.)
Thanks!
RE: Python for excel - Larz60+ - Jun-27-2020
Each excel package has it's own set of documents.
you can take a look at these here: https://pypi.org/search/?q=excel&o=
All of these packages are written by users, and so documentation will vary with authors diligence,
you can usually find it by clicking on the Homepage link on left sidebar of PyPi.
RE: Python for excel - BuJayBelvin - Jun-27-2020
Thanks! It appears some of those will be helpful. My preference is to find a textbook focused on excel via python but I am finding it might be too specific of a task for an entire textbook. Thanks for the links!
RE: Python for excel - snippsat - Jun-27-2020
BuJayBelvin - Wrote:Not sure it exists. (I have read the openpyxl documentation.)openpyxl is okay,but i find Pandas easy and more powerful to work with.
If use JupyterLab Notebook then get a similar looks,see this post.
Common Excel Tasks Demonstrated in Pandas
Common Excel Tasks Demonstrated in Pandas - Part 2.
RE: Python for excel - BuJayBelvin - Jun-27-2020
(Jun-27-2020, 09:25 AM)snippsat Wrote:BuJayBelvin - Wrote:Not sure it exists. (I have read the openpyxl documentation.)openpyxl is okay,but i find Pandas easy and more powerful to work with.
If use JupyterLab Notebook then get a similar looks,see this post.
Common Excel Tasks Demonstrated in Pandas
Common Excel Tasks Demonstrated in Pandas - Part 2.
Awesome! Thank you!
RE: Python for excel - BuJayBelvin - Jun-27-2020
Actually - after reading the snippsat post, it isn't what I am looking for exactly.
I am specifically interested in manipulating excel via Python....I understand how to do these things in Pandas (or better said, I understand that Pandas can easilly replicate excel functionality.)
I am trying to find a master reference in the form of a textbook for creating excel spreadsheets (with calculations and charts and connections to SQL) via Python.
RE: Python for excel - Yoriz - Jun-27-2020
https://www.python-excel.org/
https://www.excelpython.org/
https://groups.google.com/forum/#!topic/python-excel/5ipX5yc-gHw
RE: Python for excel - BuJayBelvin - Jun-27-2020
(Jun-27-2020, 02:41 PM)Yoriz Wrote: https://www.python-excel.org/
https://www.excelpython.org/
https://groups.google.com/forum/#!topic/python-excel/5ipX5yc-gHw
Thanks! This is getting much closer! Very much appreciated!