Python for excel

[BuJayBelvin]

Can anyone share a reference text specifically geared towards excel users? Not sure it exists. (I have read the openpyxl documentation.)

Thanks!

[Larz60+]

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.

[BuJayBelvin]

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!

[snippsat]

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.

[BuJayBelvin]

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!

[BuJayBelvin]

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.

[Yoriz]

https://www.python-excel.org/
https://www.excelpython.org/
https://groups.google.com/forum/#!topic/...ipX5yc-gHw

[BuJayBelvin]

https://www.python-excel.org/
https://www.excelpython.org/
https://groups.google.com/forum/#!topic/...ipX5yc-gHw

Thanks! This is getting much closer! Very much appreciated!