#xlsx #usv #import-export #import #export #data

bin+lib usv-to-xlsx

USV to XLSX: Convert Unicode Separated Values (USV) to Microsoft Excel (XLSX) for data markup, including for spreadsheets, databases, text files, and more

7 unstable releases (3 breaking)

0.4.1 Apr 11, 2024
0.4.0 Apr 4, 2024
0.3.2 Apr 4, 2024
0.3.1 Mar 26, 2024
0.1.0 Mar 18, 2024

#1973 in Encoding

Download history 7/week @ 2024-06-29 66/week @ 2024-07-27 1/week @ 2024-08-03

395 downloads per month

MIT OR Apache-2.0 OR GPL-2.0 OR GPL-3.0

20KB
179 lines

usv-to-xlsx

Convert Unicode Separated Values (USV) to Microsoft Excel (XLSX)(https://github.com/SixArm/usv/tree/main/doc/comparisons/xlsx). Built with the USV Rust crate.

Syntax:

stdin | usv-to-xlsx [options] | stdout

Example:

cat example.usv | usv-to-xlsx

More examples below.

Options

  • -h, --help : Print help

  • -V, --version : Print version

  • -v, --verbose... : Set the verbosity level: 0=none, 1=error, 2=warn, 3=info, 4=debug, 5=trace. Example: --verbose …

  • --test : Print test output for debugging, verifying, tracing, and the like. Example: --test

Install

Install:

cargo install usv-to-xlsx

Link: https://crates.io/crates/usv-to-xlsx

Example

Suppose example.usv contains:

a␟b␟␞
c␟d␟␞

Run:

cat example.usv | usv-to-xlsx > example.xlsx

You can now open the output file by using Microsoft Excel.

FAQ

What converters are available?

When to use this command?

Use this command when you want to convert from USV to XLSX.

A typical use case is when you have USV data, such as a collection of units and records, and you want to convert it to XLSX data, such as for a spreadsheet import.

Our real-world use case is converting a bunch of USV document-oriented data from a variety of programs, including a CMS, to USV so we're better-able to import the data into Excel.

Why use USV instead of XLSX?

See the documentation for USV.

Is USV aiming to become a standard?

Yes, USV is submitted to IETF.org as an Internet-Draft work in progress: link.

Can I build my own USV tools?

Yes, and you may freely use the USV RFC and USV Rust crate.

Help wanted

Constructive feedback welcome. Pull requests and feature requests welcome.

Tracking

  • Package: usv-to-xlsx-rust-crate
  • Version: 0.4.1
  • Created: 2024-03-09T13:33:20Z
  • Updated: 2024-04-11T19:55:29Z
  • License: MIT or Apache-2.0 or GPL-2.0 or GPL-3.0 or contact us for more
  • Contact: Joel Parker Henderson (joel@sixarm.com)

Dependencies

~10MB
~152K SLoC