fbpx
Featured

Animated Plots with matplotlib in Excel

Animated plots are a great way to liven up a spreadsheet or show a complex data set in a more intuitive way. We can use matplotlib to create animations and display them directly in Excel using PyXLL’s plotting capabilities.

Python Jupyter Notebooks in Excel

It used to be an “either/or” choice between Excel and Python Jupyter Notebooks. With the introduction of the PyXLL-Jupyter package now you can use both together, side by side.

Trending
Latest

Python in Excel for YouTube Data Research

Unlock the full potential of your YouTube video research by seamlessly integrating Python in Excel. As a content creator, staying ahead requires insightful data on video performance and trending topics. While YouTube offers valuable data, the real game-changer is having that information readily available in Excel! Traditional web scraping tools like PowerQuery fall short when

Writing a Custom Excel Function Formatter: “Fill Down” Formatting

PyXLL makes returning arrays and DataFrames of data from Python to Excel simple. Python functions can return entire tables of data directly into Excel as user defined function (or UDF). All we require to do that is PyXLL’s @xl_func decorator. Python Array Functions in Excel: https://www.pyxll.com/docs/userguide/udfs/arrayfuncs.html But what if you want to format your data

Faster Excel Workbooks with Python 3.11 and PyXLL

PyXLL 5.5.0 supports using Python 3.11 in Excel. When looking back at history of Python we may well remember Python 3.11 as a major milestone. The performance of Python has long been a topic of debate among even the most dedicated Python fans. Python detractors often quote performance as a reason (often unfounded!) not to

Use VS Code to Debug Python Functions in Excel

Visual Studio Code (or VS Code) is a lightweight programming IDE with extensions for many languages, including Python. The Python extension for VS Code features a debugger than you can use to debug Python functions in Excel. If you have used Excel’s VBA Editor then you will be used to stepping through VBA functions. With

Debug Python in Excel with PyCharm

What is PyCharm? PyCharm is an extremely popular Python IDE by JetBrains. Among it’s many features is its excellent visual debugger. The debugger lets you step through Python code, line by line, and inspect variables. We can use this to debug our Python code running in Excel. For professional developers getting a development environment set