Skip to content

Import/export as CSV or .xlsx file #19

@jgaehring

Description

@jgaehring

While refamiliarizing myself with the progress we'd made with #10, I got to thinking about other file formats we could target, and I found this handy lil CLI tool, qsv or "Quicksilver", which we might be able to crib from since it's written in Rust:

https://crates.io/crates/qsv

Specifically it has excel and to commands for reading and writing Microsoft's .xlsx format, which I believe is what RGO uses. There's even some functionality for writing to SQLite files and using Polars SQL against a collection of .csv files, which is pretty sweet!

Obviously, this is a kitchen-sink CLI utility, not ideal as a dependency. It'd be great if it's possible to import just a couple of those modules somehow, but I'm not sure what best practices are for doing that in Rust. Either way, we may also get a lot of functionality out of the csv crate, which is what Quicksilver uses under the hood:

https://crates.io/crates/csv

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions