Tutorials - page 2

TUTORIAL

How to write xlwings code that works both with a local Python installation and via remote interpreter

August 8, 2022 • By Felix Zumstein

Using xlwings with a local installation of Python makes it easy to get started, while working with the new remote interpreter may be a little harder to get started, but eventually saves you from deployment headaches. The remote interpreter also allows you to use xlwings with Docker and WSL (Windows Subsystem for Linux). To let the end-user choose whether they want to install Python locally, use a Docker container, or your centrally hosted web service,...

TUTORIAL

How to lock cells in Excel and Jupyter notebooks

December 6, 2021 • By Felix Zumstein

Excel and Jupyter notebooks have a big overlap regarding their use case (analyzing data and showing some fancy charts/numbers), which means that you’ll find yourself occasionally looking for some “Excel functionality” in Jupyter notebooks. Recently, this happened to me when a Jupyter notebook user told me that they weren’t able to use their Jupyter notebooks with non-Python savvy users since the risk of them inadvertently changing the code cells was too high. Now, in Excel,...

TUTORIAL

Bulk Create QR Codes in Excel with Python

June 8, 2021 • By Felix Zumstein

This tutorial shows you how to insert QR codes into Microsoft Excel with Python. We’ll start by writing a few lines of Python code that you could run from a Jupyter notebook or as a traditional Python script before we’ll see how we can generate QR codes at the click of a button via the xlwings add-in. To conclude, we’ll build a user-defined function (UDF) in Excel to insert QR codes. Inserting QR codes into...