xls-rs 0.1.2

A powerful CLI tool and library for spreadsheet manipulation with pandas-style operations. Supports CSV, Excel (XLSX, XLS, ODS), Parquet, and Avro formats with formula evaluation, data transformation, and comprehensive analytics capabilities.
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85

//! CLI `read` / `read-all` output format resolution (config + flags).

use std::process::Command;

#[test]
fn read_without_format_uses_csv_when_no_config_default() {
    let dir = tempfile::tempdir().unwrap();
    let input = dir.path().join("t.csv");
    std::fs::write(&input, "A,B\n1,2\n").unwrap();

    let exe = env!("CARGO_BIN_EXE_xls-rs");
    let out = Command::new(exe)
        .args([
            "--quiet",
            "read",
            "--input",
            input.to_str().unwrap(),
        ])
        .output()
        .unwrap();

    assert!(out.status.success(), "{}", String::from_utf8_lossy(&out.stderr));
    let stdout = String::from_utf8_lossy(&out.stdout);
    assert!(stdout.contains("A"));
    assert!(stdout.contains("1"));
}

#[test]
fn read_respects_default_format_from_config() {
    let dir = tempfile::tempdir().unwrap();
    let input = dir.path().join("t.csv");
    std::fs::write(&input, "A,B\n1,2\n").unwrap();
    let cfg = dir.path().join("cfg.toml");
    std::fs::write(&cfg, "default_format = \"json\"\n").unwrap();

    let exe = env!("CARGO_BIN_EXE_xls-rs");
    let out = Command::new(exe)
        .args([
            "--quiet",
            "--config",
            cfg.to_str().unwrap(),
            "read",
            "--input",
            input.to_str().unwrap(),
        ])
        .output()
        .unwrap();

    assert!(out.status.success(), "{}", String::from_utf8_lossy(&out.stderr));
    let stdout = String::from_utf8_lossy(&out.stdout);
    let trimmed = stdout.trim();
    assert!(
        trimmed.starts_with('['),
        "expected JSON array, got: {trimmed:?}"
    );
}

#[test]
fn read_explicit_format_overrides_config() {
    let dir = tempfile::tempdir().unwrap();
    let input = dir.path().join("t.csv");
    std::fs::write(&input, "A,B\n1,2\n").unwrap();
    let cfg = dir.path().join("cfg.toml");
    std::fs::write(&cfg, "default_format = \"json\"\n").unwrap();

    let exe = env!("CARGO_BIN_EXE_xls-rs");
    let out = Command::new(exe)
        .args([
            "--quiet",
            "--config",
            cfg.to_str().unwrap(),
            "read",
            "--input",
            input.to_str().unwrap(),
            "--format",
            "csv",
        ])
        .output()
        .unwrap();

    assert!(out.status.success(), "{}", String::from_utf8_lossy(&out.stderr));
    let stdout = String::from_utf8_lossy(&out.stdout);
    assert!(!stdout.trim_start().starts_with('['));
    assert!(stdout.contains("A"));
}