PyXLL LtdWhat 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 Development & Training Tools category of a tech stack.
Key Features
User Defined Functions: Write Excel worksheet functions in Python - no VBA requiredRibbon Customization: Give your users a rich Excel native experienceMacros: No need for VBA, access to the full Excel Object Model in PythonMenu Functions: Call Python functions from Excel menus, and give common tasks keyboard shortcutsReal Time Data: Stream data to Excel in real-time using PythonArray Functions: Return tables of data to Excel that resize automaticallyIntelliSense: Auto-complete worksheet functions as you type themNumPy and Pandas Integration: Use NumPy and Pandas types in Excel
PyXLL Pros & Cons
Pros of PyXLL
- ✓Fully replace VBA with Python
- ✓Excellent support
- ✓Very good performance
Cons of PyXLL
- ✗Cannot be deloyed to mac users
PyXLL Alternatives & Comparisons
What are some alternatives to PyXLL?
NumPy
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.
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.
SciPy
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.
