umya-spreadsheet
xlite
| umya-spreadsheet | xlite | |
|---|---|---|
| 1 | 16 | |
| 222 | 1,230 | |
| - | - | |
| 8.8 | 0.9 | |
| 11 days ago | about 1 year ago | |
| Rust | Rust | |
| MIT License | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
umya-spreadsheet
-
Roast my app: After 2 weeks learning Rust and Tauri, I hacked a few libraries together to build a simple Spreadsheet
https://github.com/MathNya/umya-spreadsheet for reading and writing xlsx files on the backend
xlite
-
Show HN: Query Your Sheets with SheetSQL
There is similar open-source project for Google Sheets: https://github.com/0x6b/libgsqlite (SQLite extension), which is a fork of https://github.com/x2bool/xlite (same idea but for Microsoft Excel spreadsheets)
-
Query Google Sheets as virtual tables with SQLite extension – libgsqlite
This project actually started as a fork of https://github.com/x2bool/xlite - SQLite extension for querying .xls and .xlsx spreadsheets.
-
A SQLite extension for reading large files line-by-line
Hey, author here, happy to answer any questions! Also checkout this notebook for a deeper dive into sqlite-lines, along with a slick WASM demonstration and more thoughts on the codebase itself https://observablehq.com/@asg017/introducing-sqlite-lines
I really dig SQLite, and I believe SQLite extensions will push it to another level. I rarely reach for Pandas or other "traditional" tools and query languages, and instead opt for plain ol' SQLite and other extensions. As a shameless plug, I recently started a blog series on SQLite and related tools and extensions if you want to learn more! Next week I'll be publishing more SQLite extensions for parsing HTML + making HTTP requests https://observablehq.com/@asg017/a-new-sqlite-blog-series
A few other SQLite extensions:
- xlite, for reading Excel files, in Rust https://github.com/x2bool/xlite
- sqlean, several small SQLite extensions in C https://github.com/nalgeon/sqlean
- mergestat, several SQLite extensions for developers (mainly Github's API) in Go https://github.com/mergestat/mergestat
- Processing Excel files in SQLite
- What's everyone working on this week (26/2022)?
- SQLite extension to query Excel spreadsheets (.xls, .xlsx, .ods)
- SQLite extension to query Excel (.xlsx, .xls, .ods) files as virtual tables
- Xlite。将Excel和Open Document电子表格作为SQLite虚拟表进行查询 (Xlite: Query Excel and Open Document spreadsheets as SQLite virtual tables)
- Interesting project? dynamic lib, .so .dll, Xlite SQLite
What are some alternatives?
calamine - A pure Rust Excel/OpenDocument SpreadSheets file reader: rust on metal sheets
spacedrive - Spacedrive is an open source cross-platform file explorer, powered by a virtual distributed filesystem written in Rust.
xlsxwriter-rs - Excel file writer for Rust
uom - Units of measurement -- type-safe zero-cost dimensional analysis
excel2json - Convert excel file to json data
asammdf - a rust crate to parse and write ASAM MDF file.
pulsars - A Tauri-based spreadsheet
dsq - Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and more.
x-spreadsheet - The project has been migrated to @wolf-table/table https://github.com/wolf-table/table
visidata - A terminal spreadsheet multitool for discovering and arranging data
advanced-formula-environment - Create, edit, and reuse formulas in Excel
Envy - Envy. Multi P2P Filesharing+Bittorrent, Shareaza Legacy.