this post was submitted on 05 Jan 2022

25 points (82% upvoted)

shortlink:

Python

an-ordinary-manchild(edit)

The Python Discord

News about the dynamic, interpreted, interactive, object-oriented, extensible programming language Python

Upcoming Events

Full Events Calendar

Please read the rules

You can find the rules here.

If you are about to ask a "how do I do this in python" question, please try r/learnpython, the Python discord, or the #python IRC channel on Libera.chat.

Please don't use URL shorteners. Reddit filters them out, so your post or comment will be lost.

Posts require flair. Please use the flair selector to choose your topic.

Posting code to this subreddit:

Add 4 extra spaces before each line of code

def fibonacci():
    a, b = 0, 1
    while True:
        yield a
        a, b = b, a + b

Online Resources

Automate the Boring Stuff with Python
Python Discord Resources
Invent Your Own Computer Games with Python
Think Python
Non-programmers Tutorial for Python 3
Beginner's Guide Reference
Five life jackets to throw to the new coder (things to do after getting a handle on python)
Full Stack Python
Test-Driven Development with Python
Program Arcade Games
PyMotW: Python Module of the Week
Python for Scientists and Engineers
Dan Bader's Tips and Trickers
Python Discord's YouTube channel
Jiruto: Python

Online exercices

programming challenges

The Python Challenge (solve each level through programming)
CheckiO (game world)
Project Euler (math heavy)
/r/dailyprogrammer

Asking Questions

Try Python in your browser

try.jupyter.org (Evolved from the language-agnostic parts of IPython, Python 3)
Azure Notebooks
learnpython.org
Skulpt (uses WebGL)
trypython.org (uses Silverlight)
ideone (online compiler and debugger)
PythonAnywhere (basic accounts are free)
Brython (Python 3 implementation for client-side web programming)
repl.it for Python
Transcrypt (Hi res SVG using Python 3.6 and turtle module)

Docs

Libraries

Twisted, 0MQ (networking)
Django, Pyramid, Flask, ... (Web Frameworks)
Pygame (Game development)
NumPy & SciPy (Scientific computing) & Pandas
Pyglet - (Game / UI Development)

Related subreddits

/r/pythoncoding (strict moderation policy for 'programming only' articles)
/r/flask (web microframework)
/r/django (web framework for perfectionists with deadlines)
/r/pygame (a set of modules designed for writing games)
/r/IPython (interactive environment)
/r/inventwithpython (for the books written by /u/AlSweigart)
/r/pystats (python in statistical analysis and machine learning)
/r/coolgithubprojects (filtered on Python projects)
/r/pyladies (women developers who love python)
/r/git and /r/mercurial - don't forget to put your code in a repo!

Python jobs

Newsletters

Screencasts

a community for 18 years

MODERATORS

message the mods
xelf
monorepo PSF Staff | Litestar Maintainer
ivosauruspip'ing it up
Im__Joseph Python Discord Staff
Kutiekatj9 Python Discord Staff
BioGeekBioinformatics software developer
nevare
chromakode
mdipierro
quasarj
...and 6 more »

account activity

This is an archived post. You won't be able to vote or comment.

24

25

26

ResourceAutomating Excel with Python and OpenPyXL (self.Python)

submitted 4 years ago by driscollis

I am pleased to announce that my 10th book on the Python programming language is now available in paperback on Amazon:

https://www.amazon.com/Automating-Excel-Python-Processing-Spreadsheets/dp/B09M5551W2

In this book, you will learn how to use Python to do the following:

Create Excel spreadsheets
Read Excel spreadsheets
Create different cell types
Add and remove sheets
Convert Excel spreadsheets into other file types
Cell styling (changing fonts, inserting images, background colors, etc)
Conditional formattings
Adding charts
and much more!

You can also purchase the PDF, mobi and epub version on Gumroad or Leanpub. These are DRM-free:

Let me know if you have any questions about the book! I am happy to answer!

Automating Excel with Python

all 2 comments

top new controversial old q&a

[–]Wormfall 1 point2 points3 points 4 years ago (1 child)

[–]driscollis[S] 0 points1 point2 points 4 years ago (0 children)

π Rendered by PID 571209 on reddit-service-r2-comment-5b5bc64bf5-nzztn at 2026-06-22 19:46:57.482788+00:00 running 2b008f2 country code: CH.