3 ms·
There are extensions that let you query Excel worksheet files directly from SQLite (no importing, no transformation, just direct query). It's quite fun to do; y
by bambax 2y ago
There are extensions that let you query Excel worksheet files directly from SQLite (no importing, no transformation, just direct query). It's quite fun to do; you can use Excel (or Libre office, etc.) to maintain the spreadsheet, and build reports with SQLite.
- zoomablemind 2y agoCould you mention a few of such, to save time going through search results?
- bambax 2y agoThe one I use is xlite https://github.com/x2bool/xlite https://github.com/x2bool/xlite It's read-only and mounts spreadsheets as virtual tables. Very fast. Perhaps more relevant to this thread, libgsqlite loads Google Sheets as virtual tables: https://github.com/0x6b/libgsqlite https://github.com/0x6b/libgsqlite (I haven't tested it though.)