Skip to content

Use Python to replace VBA in Excel

Play Open on YouTube
2020 17 min PyXLL - Write Excel Add-Ins with Python and Java en YouTube

Did you know that you can completely replace VBA in Excel with Python? Script and automate Excel using nothing but Python, and write macro functions (Subs) and worksheet functions (UDFs) using PyXLL. PyXLL https://www.pyxll.com Resources for VBA developers https://www.pyxll.com/learn-python

Chapters

  1. 0:00 Start
  2. 0:47 start a python prompt
  3. 4:29 call the select method on the range
  4. 6:30 embed python into the excel process
  5. 6:51 use the pixel add-in or py xll
  6. 10:35 get the cells collection from this column
  7. 14:13 using the excel func decorator
Channel
PyXLL - Write Excel Add-Ins with Python and Java
Tags
Python
Views
189

More like this

3:47:58

The ultimate introduction to Pygame
7:38:56

Creating a Zelda style game in Python [with some Dark Souls elements]
1:03:46

Deploying FastAPI Apps Over HTTPS with Traefik Proxy
15:16

Observer Pattern Tutorial: I NEVER knew events were THIS powerful 🚀
1:24:05

Python: The Documentary | An origin story
9:29:02

Super Mario style game in PyGame
14:54

15 Python Libraries You Should Know About in 2023
48:53

Creating Minecraft in Python