What is PyXLL?
Integrate Python into Microsoft Excel. Use Excel as your user-facing front-end with calculations, business logic and data access powered by Python. Works with all 3rd party and open source Python packages. No need to write any VBA!
PyXLL is a tool in the Data Science Tools category of a tech stack.
Who uses PyXLL?
6 developers on StackShare have stated that they use PyXLL.
Pros of PyXLL
Fully replace VBA with Python
Very good performance
- User Defined Functions: Write Excel worksheet functions in Python - no VBA required
- Ribbon Customization: Give your users a rich Excel native experience
- Macros: No need for VBA, access to the full Excel Object Model in Python
- Menu Functions: Call Python functions from Excel menus, and give common tasks keyboard shortcuts
- Real Time Data: Stream data to Excel in real-time using Python
- Array Functions: Return tables of data to Excel that resize automatically
- IntelliSense: Auto-complete worksheet functions as you type them
- NumPy and Pandas Integration: Use NumPy and Pandas types in Excel
PyXLL Alternatives & Comparisons
What are some alternatives to PyXLL?
See all alternatives
Replace your VBA code with Python, a powerful yet easy-to-use programming language that is highly suited for numerical analysis. Supports Windows & Mac!
Build live streaming dashboards and complex mathematical models, all in Excel. You can use DataNitro to turn a spreadsheet into a database GUI - or a web server backend.
Flexible and powerful data analysis / manipulation library for Python, providing labeled data structures similar to R data.frame objects, statistical functions, and much more.
Besides its obvious scientific uses, NumPy can also be used as an efficient multi-dimensional container of generic data. Arbitrary data-types can be defined. This allows NumPy to seamlessly and speedily integrate with a wide variety of databases.
Python-based ecosystem of open-source software for mathematics, science, and engineering. It contains modules for optimization, linear algebra, integration, interpolation, special functions, FFT, signal and image processing, ODE solvers and other tasks common in science and engineering.