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?
Companies
Developers
7 developers on StackShare have stated that they use PyXLL.
PyXLL Integrations
Pros of PyXLL
5
2
1
PyXLL's Features
- 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?
xlwings
Replace your VBA code with Python, a powerful yet easy-to-use programming language that is highly suited for numerical analysis. Supports Windows & Mac!
DataNitro
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.
Pandas
Flexible and powerful data analysis / manipulation library for Python, providing labeled data structures similar to R data.frame objects, statistical functions, and much more.
jQuery
jQuery is a cross-platform JavaScript library designed to simplify the client-side scripting of HTML.
React
Lots of people use React as the V in MVC. Since React makes no assumptions about the rest of your technology stack, it's easy to try it out on a small feature in an existing project.
