{"repo":"RusselWebber/xlDuckDb","free":true,"listed":false,"github":"https://github.com/RusselWebber/xlDuckDb","clone":"git clone https://github.com/RusselWebber/xlDuckDb.git","description":"Use DuckDB within Excel with the xlDuckDb addin","language":"C#","stars":147,"topics":["duckdb","excel","exceldna"],"license":"MIT","category":"databases-storage","readme_excerpt":"xlDuckDb Use DuckDB within Excel with the xlDuckDb addin. DuckDB is an amazing tool with deep integration with Python and R, but sometimes you just need data in Excel. xlDuckDb allows DuckDB SQL to be run within Excel. Query results are returned as regular Excel cells. Installation Download the xlduckdb.zip file from the latest release on the right. Use the \"Extract All\" option on the right-click menu in Windows Explorer to extract contents of the zip file on your local PC. Right-click on the xlDuckDb64.xll file and unblock it: Double click on the xlDuckDb64.xll file to open the addin in Excel. The function DuckDbQuery will be registered automatically. Requirements xlDuckDb only runs on 64-bit Excel 365 released after Sept 2018. The dynamic array resizing functionality is required. xlDuckDb v0.6.0 and above require the .Net 8.0 or later runtime. Usually a compatible version of .Net will already be installed, however the RunTime can also be downloaded from .Net RunTime Usage Any DuckDB SQL can be run and the results will be returned to Excel. A note on copying queries into Excel When copying text such as SQL commands into Excel cells, add a ' at the start so that Excel treats the input as a string. Querying Excel Ranges Excel ranges can be queried as if the range was a regular DuckDb table. The keyword xlRange is used in queries, internally xlDuckDb substitutes the Excel range data. SELECT \\ FROM xlRange The range is passed as the third argument to the DuckDbQuery() function. ","default_branch":null,"files":null,"tree":[],"storefront":"/r/RusselWebber","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/RusselWebber/xlDuckDb/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}