PyXLL LtdPyXLL
Development & TrainingWhat 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 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?
TensorFlow
TensorFlow is an open source software library for numerical computation using data flow graphs. Nodes in the graph represent mathematical operations, while the graph edges represent the multidimensional data arrays (tensors) communicated between them. The flexible architecture allows you to deploy computation to one or more CPUs or GPUs in a desktop, server, or mobile device with a single API.
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.
Jupyter
The Jupyter Notebook is a web-based interactive computing platform. The notebook combines live code, equations, narrative text, visualizations, interactive dashboards and other media.
