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.
JavaScript
JavaScript is most known as the scripting language for Web pages, but used in many non-browser environments as well such as node.js or Apache CouchDB. It is a prototype-based, multi-paradigm scripting language that is dynamic,and supports object-oriented, imperative, and functional programming styles.
Git
Git is a free and open source distributed version control system designed to handle everything from small to very large projects with speed and efficiency.
