xloil VS sqllex

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

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)

xlOil https://github.com/cunnane/xloil

P.S.:Here is few useful links: — Sqllex ORM (github page) — Sqllex docs — Project showcase — Another example #0 — Another example #1

FYI: If you're looking for something with more than one user, take a look at sqllex, which is a great query builder along the same lines. I made HissDB because sqllex didn't parameterize its queries, but I believe they've fixed that issue since then.

Sqllex it's nice Python ORM available for SQLite and PostgreSQL. I have made many examples and posts about this. So let me know what you think about this project.

Just released SQLLEX v0.2.0.0 after 2 months of preparing. Sqllex it's ORM for SQLite and (by now) PostgreSQL. I made many examples and posts about it. And I'll be happy if you'll try it by yourself in your projects.

"SQLLEX | Awesome example #1"

How I got later, this technology calls ORM (Object-Relational Mapping) and I'm not the first one who create something like this. But in my opinion, SQLLEX is the most intuitive ORM I'v ever seen and I'm interested what do you think. Check this out.

Last few months I'm working on my biggest project Sqllex. All this time I have been using the wiki tab (on github) to document the project. But this project is getting so big that it gets really difficult.

Sqllex - just a nice tool for comfortable and safe working with SQLite databases.

Sqllex package has been downloaded from pypi.org over 550 times, github repo got 45 new stars.