The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning. Learn more →
Xloil Alternatives
Similar projects and alternatives to xloil
-
xlwings
xlwings is a Python library that makes it easy to call Python from Excel and vice versa. It works with Excel on Windows and macOS as well as with Google Sheets and Excel on the web.
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
-
msgraph-sample-office-addin
This sample demonstrates how to use the Microsoft Graph JavaScript SDK to access data in Office 365 from Office Add-ins.
-
dbd
dbd is a database prototyping tool that enables data analysts and engineers to quickly load and transform data in SQL databases.
-
WorkOS
The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
NOTE:
The number of mentions on this list indicates mentions on common posts plus user suggested alternatives.
Hence, a higher number means a better xloil alternative or higher similarity.
xloil reviews and mentions
Posts with mentions or reviews of xloil.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-03-03.
-
XlOil: The fastest library for writing Excel functions in Python
I recently discovered xlOil after many years with xlWings and periodically checking for other options out there. xlOil is an order of magnitude faster than xlWings or VBA (benchmarks taken from here: https://github.com/lukedays/excel-benchmarks) while still being easy to use and the most feature complete!
With xlOil, you can easily write functions in Python and have them appear in Excel as worksheet functions and macros.
What sets xlOil apart is its ability to have very low overheads when calling your own worksheet functions. This means you can write complex functions without sacrificing performance. xlOil supports different languages via plugins, including C++, Python, and SQL.
With xlOil, you'll have access to a range of features that make writing Excel functions in Python a breeze. For instance, the Python syntax for declaring Excel functions is incredibly concise, and you can use optional type checking of function parameters and support for keyword arguments. xlOil also offers tight integration with numpy, so you can enjoy very low overheads for array functions.
Another advantage of xlOil is its support for a range of data structures, including tuples, lists, dictionarys, and pandas dataframes. Additionally, you can use xlOil to write async functions, RTD functions, and on-the-fly RTD server creation. xlOil also supports macro-type functions that write to ranges on the sheet, and you can access the Excel Application object, hook Excel events, and pass any python object back to Excel and then back into any python function.
xlOil even offers simple and quick add-in deployment and two-way connection to Jupyter notebooks, making it easy to run worksheet functions in Jupyter and query variables in the jupyter kernel. On-the-fly creation/destruction of COM addin objects and Ribbon UI is also supported.
Check it out on Github and star it to encourage the developer to keep supporting this great contribution to the Open Source community!
https://github.com/cunnane/xloil
- GitHub - cunnane/xloil: xlOil provides framework for interacting with Excel in different programming languages (python & C++ currently)
-
XlOil: Easy Excel Integration for Python and SQL
Some benchmarks here comparing to xlwings: https://github.com/cunnane/xloil/discussions/6 (although these are slightly out of date and xloil is now faster)
-
Running python from excel
xlOil https://github.com/cunnane/xloil
-
A note from our sponsor - WorkOS
workos.com | 26 Apr 2024
Stats
Basic xloil repo stats
5
117
8.8
26 days ago
cunnane/xloil is an open source project licensed under GNU General Public License v3.0 or later which is an OSI approved license.
The primary programming language of xloil is C++.
Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com