🚨 It's finally here! Python in Excel

from PyByte import whats_new, trick_of_the_week, get_inspired, fun_or_funny

# Welcome to the PyByte!

👋 Hey, and thanks for joining PyByte, a quick way to inject Python into your week!

whats_new()

🚨 Python in Excel is now available to all users in the Beta channel! 🚨

To get access, you need to have a Office 365 subscription on a Windows machine and then make sure you’re on the Beta channel.

To run your first script in Excel:

1. Select Formulas in the ribbon

2. Select Insert Python.

3. In the dialog that appears, select the Try preview button.

I have been playing around with it this week and for once in a long time, I am stoked about using Excel.

trick_of_the_week()

Unused code presents several problems, which include:

• Making it way harder to read and understand code. 🤔

• Adds excessive utilization of memory and resources. 😵

• Your coworkers might make fun of you. 🙃

The below code has an unused import and an unused function 😥

To help you identify and remove unused Python code, use Vulture!

First, install vulture with pip.

$ pip install vulture

Then enter the following into your terminal/command line/Powershell on your script.

$ vulture myscript.py  # or
$ python3 -m vulture myscript.py
$ vulture myscript.py mypackage/
$ vulture myscript.py --min-confidence 100  # Only report 100% dead code.

Link to Vulture: https://github.com/jendrikseipp/vulture

get_inspired()

fun_or_funny()

From X/Twitter:

See you next week 👋

Joel