Top 7 Rust Excel Projects

qsv

13 2,234 9.9 Rust

CSVs sliced, diced & analyzed.

Project mention: Qsv: Efficient CSV CLI Toolkit | news.ycombinator.com | 2023-12-22

Thanks for the detailed feedback @snidane!
As maintainer of qsv, here's my reply:
- Given qsv's rapid release cycle (173 releases over three years), the auto-update check is essential at the moment. Once we reach 1.0, I'll turn it off. For now, given your feedback, I've only made it check 10% of the time.
- Pivot is in the backlog and I'll be sure to add unpivot when I implement it. (https://github.com/jqnatividad/qsv/issues/799)
- I'll add a dedicated summing command with the group by (-by) and window by (-over) capability (https://github.com/jqnatividad/qsv/issues/1514). Do note that `stats` has basic sum as @ezequiel-garzon pointed out.
- With the `enum` command, qsv can achieve what you proposed with `laminate`. E.g. qsv enum --new-column newcol --constant newconstant mydata.csv --output laminated-data.csv
- With the cat rowskey command, qsv can already concatenate files with mismatched headers.
- other file formats. qsv supports parquet, csv, tsv, excel, ods, datapackage, sqlite and more (see https://github.com/jqnatividad/qsv/tree/master#file-formats). Fixed-format though is not supported yet and quite interesting, and have added it to the backlog (https://github.com/jqnatividad/qsv/issues/1515)
- as to "enable embedding outputs of commands", qsv is composable by design, so you can use standard stdin/stdout redirection/piping techniques to have it work with other CLI tools like jq, awk, etc.
Finally, just released v0.120.0 that already incorporates the less aggressive self-update check. https://github.com/jqnatividad/qsv/releases/tag/0.120.0

calamine

3 1,523 8.8 Rust

A pure Rust Excel/OpenDocument SpreadSheets file reader: rust on metal sheets
InfluxDB

www.influxdata.com featured

Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
xlite

16 1,230 0.9 Rust

Query Excel spredsheets (.xlsx, .xls, .ods) using SQLite

Project mention: Show HN: Query Your Sheets with SheetSQL | news.ycombinator.com | 2024-03-13

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)

umya-spreadsheet

1 221 8.8 Rust

A pure rust library for reading and writing spreadsheet files
rsv

1 115 6.3 Rust

rsv is a command line tool written in Rust to analyze directly from disk small and large CSV, TXT, EXCEL files (e.g., >10G). Support data slicing, filtering, spliting, generating frequency table, etc. (by ribbondz)
excel2json

2 88 4.6 Rust

Convert excel file to json data
csv-plus-plus

1 24 9.4 Rust

csv++ - Spreadsheets as Code

Project mention: CSV++ | news.ycombinator.com | 2023-12-22

SaaSHub

www.saashub.com featured

SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020).

Rust Excel related posts

Pomoc pocetniku oko 10Gbe umrezavanja

1 project | /r/programiranje | 28 Apr 2023
Roast my app: After 2 weeks learning Rust and Tauri, I hacked a few libraries together to build a simple Spreadsheet

3 projects | /r/rust | 22 Mar 2023
Meet FastExcel, the fastest excel reader wrote in rust with a python binding.

2 projects | /r/rust | 23 Nov 2022