Bring Your Spyder Workflow Into Excel If you’re already a Spyder IDE user, you’re used to: With PyXLL and the companion package pyxll-spyder, you can bring that exact same workflow into Microsoft Excel. This means you can continue using the tools and environment you already enjoy, while unlocking the ability to: If you already use
Hit Enter, and your formula runs… but Excel is locked solid. No scrolling. No edits. Just waiting. With PyXLL, it doesn’t have to be that way. You can run long Python functions without freezing Excel — and even show live progress updates while they work. Here’s how. What is a long running function? Ever written
Excel is where many business decisions get made. But when it comes to creating rich, interactive dashboards or data-driven applications, Python tools like Plotly Dash offer flexibility and power that Excel alone can’t match. Plotly Dash is a Python framework for building interactive web apps and dashboards using just Python—no JavaScript required. It’s popular among
Monte Carlo simulations are essential as an analytical tool in various fields, from finance to project management. Using Python and the PyXLL add-in we’ll explore how to bring the Monte Carlo method to Excel. This Monte Carlo statistical technique allows us to understand and quantify uncertainty by performing repeated random sampling to obtain numerical results.
A customer recently asked me how to create a live, updating, real-time chart in Excel using the Python Excel add-in PyXLL. It turns out with the right plotting library it’s much easier than you might think! In this tutorial, we’ll explore how to combine Python’s HoloViz and Panel libraries with PyXLL to create a dynamic