{"repo":"x2bool/xlite","free":true,"listed":false,"github":"https://github.com/x2bool/xlite","clone":"git clone https://github.com/x2bool/xlite.git","description":"Query Excel spredsheets (.xlsx, .xls, .ods) using SQLite","language":"Rust","stars":1306,"topics":["excel","sql","sqlite","sqlite3","xls","xlsx","ods","sqlite-extension","sqlite-virtual-table"],"license":"MIT","category":"databases-storage","readme_excerpt":"XLite - query Excel (.xlsx, .xls) and Open Document spreadsheets (.ods) as SQLite virtual tables XLite is a SQLite extension written in Rust. The main purpose of this library is to allow working with spreadsheets from SQLite exposing them as virtual tables. Download The following prebuilt libraries are available for download: Linux Windows MacOS -- -- -- -- x86 libxlite.so.tar.gz️ xlite.dll.zip️ N/A x86-64 libxlite.so.tar.gz️ xlite.dll.zip️ libxlite.dylib.zip AArch64 (ARM64) libxlite.so.tar.gz️ libxlite.dylib.zip This step will produce libxlite.so or libxlite.dylib or xlite.dll depending on your operation system. How to use Assuming you have sqlite3 command line tools installed, libxlite library in your current directory and some spreadsheet file on your disk you can load extension: This will load xlite module, now it can be used to create virtual tables. Creating a virtual table (this sample uses the .xslx file from the tests directory): Explanation: this statement will create a virtual table based on the .xlsx file and the worksheet named \"Sheet1\". Optional RANGE parameter is used here to skip the first row in the table. A2:F meaning is use columns from A to F but start from 2nd row . Querying: Columns are named according to their name (index) in the spreadsheet, unless an optional COLNAMES argument is provided - in this case column names will be taken from the row of spreadsheet specified by this option. All operations supported by SQLite can be executed on spreadsheets as","default_branch":null,"files":null,"tree":[],"storefront":"/r/x2bool","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/x2bool/xlite/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."}