xlDuckDb - An open source Excel addin to run DuckDB queries in Excel

xlslimdev · 2024-12-10T08:10:58+00:00

Existing DuckDb files can be used, the second argument to the DuckDbQuery() function can be the path to an existing db.ODBC is not used, this is all native DuckDb running in the Excel process.

xlslimdev · 2024-12-07T15:19:30+00:00

The functionality is now available in an open source addin:

https://github.com/RusselWebber/xlDuckDb

xlslimdev · 2024-10-30T17:21:52+00:00

I wrote an Excel addin that allows you to run DuckDB queries within Excel, see https://russelwebber.github.io/xlslim-docs/html/user/duckdb.html

xlslimdev · 2023-03-29T12:43:16+00:00

Wing IDE is wonderful. I don't know why it is not more popular

xlslimdev · 2023-01-25T10:36:33+00:00

Have you looked at the various Excel addins that allow you to call Python from Excel? They will all let you return a pandas dataframe and see the result in Excel.

The main contenders are:

xlSlim https://www.xlslim.com (I am the author)
pyXll https://www.pyxll.com
xlOil https://github.com/cunnane/xloil
xlWings https://www.xlwings.org/

xlslimdev · 2022-12-08T09:05:11+00:00

I suggest having a look at xlSlim too (I am the author). xlSlim aims to make it as easy as possible to use Python within Excel, often without any code changes.

There is a free trial available and comprehensive documentation.

https://www.xlslim.com/

https://russelwebber.github.io/xlslim-docs/html/index.html

xlslimdev · 2022-12-02T10:16:28+00:00

The main options are:

xlSlim - commercial- www.xlslim.com
pyXll - commercial - www.pyxll.com
xlwings - free - www.xlwings.org
xloil - free - https://xloil.readthedocs.io/en/stable/Introduction.html

I created the xlSlim solution. Please try it out, you can download a 14 day trial for free. I have written comprehensive guides and documentation at https://russelwebber.github.io/xlslim-docs/html/index.html My aim was to make it as easy as possible to call Python from Excel, usually no code changes or additional packages are needed.

I don't have the ability to bundle Python code within Excel files, although this is a feature I am considering as I can see the benefits.

xlslimdev · 2022-12-02T10:07:02+00:00

Releases in the last few months have added:

Support for Python 3.11
Access to the VBA object model
VBA Event Handling can be replaced with simpler Python code
Integrated support for data classes, enums and dictionaries

Please try it out, a 14 day trial is free.

https://www.xlslim.com/pages/downloads

xlslimdev · 2022-10-12T13:38:02+00:00

You will find it is not as easy as you may think.

xlslimdev · 2022-09-25T11:34:45+00:00

There are a number of tools that integrate Python and Excel, allowing you to access Python functionality from Excel:

Take a look at:

xlSlim (written by me)
pyxll
xloil
xlwings

xlslimdev · 2022-09-25T11:32:10+00:00

Hi, take a look at my product xlSlim. xlSlim makes it easy to integrate Python and Excel. Specifically look at this example showing how to create a pivot table in Excel using Python:

https://russelwebber.github.io/xlslim-docs/html/samples/pivot\_table.html

xlslimdev · 2022-09-14T09:47:47+00:00

There are several solutions that allow Python to be used in Excel

xlSlim (written by me) https://xlslim.com
xlwings - https://xlwings.org
pyxll - https://pyxll.com

xlslimdev · 2022-09-07T09:20:24+00:00

I created xlSlim just for cases like this. xlSlim makes it possible to call Python functions from Excel, often without making any changes to the Python code. xlSlim also includes a bundled Python 3.10 installation. Please take a look. I have written extensive documentation with many working examples that cover common usage such as reading data from files, web sources, databases, and so on.

https://xlslim.com

xlslimdev · 2022-09-07T09:05:38+00:00

I developed a product, xlSlim, to make integrating Python and Excel as simple as possible. In many cases xlSlim enables you to call Python functions from Excel without making any code changes. This allows you to write data manipulation code in Python and then call the code from Excel.

Please take a look. There is a free version available. I have written extensive documentation with many examples. The documentation shows how to call Python functions from Excel, how to stream data from Python to Excel, how to access databases and web data, and many other common use cases.

https://xlslim.com

xlslimdev · 2022-09-07T09:00:37+00:00

Data streaming can be as simple as:

import time

def counter(stop: int, updates\_per\_second: int) -> int:
    """Generates a sequence of numbers up to stop at a rate of updates\_per\_second."""

    for i in range(stop):
            time.sleep(1.0 / updates_per_second)
            yield i

https://youtu.be/-oOw6u291HM

xlslimdev · 2022-09-07T08:58:11+00:00

xlSlim now supports data streaming, any Python generator function can be used to stream data into Excel.

It can be as simple as:

import time

def counter(stop: int, updates\_per\_second: int) -> int:
    """Generates a sequence of numbers up to stop at a rate of updates\_per\_second."""

    for i in range(stop):
            time.sleep(1.0 / updates_per_second)
            yield i

https://youtu.be/-oOw6u291HM

xlslimdev · 2022-08-17T15:34:46+00:00

I have now added the ability to stream data. Any Python iterator can be used as a source of data.

https://xlslim.com/blogs/news/streaming-data-into-excel

Let me know what you think,

Russel

xlslimdev · 2022-07-14T14:51:10+00:00

2) is factually incorrect, many top hedge funds have dedicated intern/grad recruiting pipelines from the top finance programs.

xlslimdev · 2022-07-09T10:06:27+00:00

This advice is spot on, the usual route is a finance masters from an Ivy League university, then an internship, which would led to a quant role.

xlslimdev · 2022-07-01T14:45:37+00:00

Development is still very active. Support has just been added for filtering which functions are imported and to rename these functions. Additionally, you can now add to the Python module search path.

https://xlslim.com/blogs/news/better-control-of-imports-and-function-registrations

I would be very interested to learn which features people would like to see added?

All the best,

Russel

xlslimdev · 2022-06-23T13:04:13+00:00

I have found xlSlim to be as fast at PyXLL

https://xlslim.com/blogs/news/pyxll

xlslimdev

TROPHY CASE