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
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100

//! Capability catalog shared by CLI/MCP.

#[derive(Debug, Clone, Copy, PartialEq, Eq)]
pub enum CapabilitySurface {
    Library,
    Cli,
    Mcp,
}

#[derive(Debug, Clone, Copy, PartialEq, Eq)]
pub enum CapabilityKind {
    Io,
    Transform,
    Analytics,
    Advanced,
}

#[derive(Debug, Clone, Copy, PartialEq, Eq)]
pub struct Capability {
    pub name: &'static str,
    pub kind: CapabilityKind,
}

pub const CAPABILITIES: &[Capability] = &[
    // I/O
    Capability {
        name: "read",
        kind: CapabilityKind::Io,
    },
    Capability {
        name: "write",
        kind: CapabilityKind::Io,
    },
    Capability {
        name: "convert",
        kind: CapabilityKind::Io,
    },
    Capability {
        name: "sheets",
        kind: CapabilityKind::Io,
    },
    Capability {
        name: "read_all",
        kind: CapabilityKind::Io,
    },
    // Transforms
    Capability {
        name: "sort",
        kind: CapabilityKind::Transform,
    },
    Capability {
        name: "filter",
        kind: CapabilityKind::Transform,
    },
    Capability {
        name: "replace",
        kind: CapabilityKind::Transform,
    },
    Capability {
        name: "dedupe",
        kind: CapabilityKind::Transform,
    },
    Capability {
        name: "transpose",
        kind: CapabilityKind::Transform,
    },
    Capability {
        name: "select",
        kind: CapabilityKind::Transform,
    },
    // Analytics-ish
    Capability {
        name: "head",
        kind: CapabilityKind::Analytics,
    },
    Capability {
        name: "tail",
        kind: CapabilityKind::Analytics,
    },
    Capability {
        name: "describe",
        kind: CapabilityKind::Analytics,
    },
    // Advanced
    Capability {
        name: "validate",
        kind: CapabilityKind::Advanced,
    },
    Capability {
        name: "profile",
        kind: CapabilityKind::Advanced,
    },
    Capability {
        name: "schema",
        kind: CapabilityKind::Advanced,
    },
];

pub const FORMATS: &[&str] = &["csv", "xlsx", "xls", "ods", "parquet", "avro", "json"];