excel-cli 1.3.2

Excel CLI for AI, scripting, and terminal users. Headless JSON API for automation, plus a Vim-like TUI for interactive browsing and editing.
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

use serde_json::{json, Value};

/// Build a standard v1.0 success envelope.
pub fn success_envelope(
    command: &str,
    file_path: &str,
    file_format: &str,
    target: Value,
    meta: Value,
    data: Value,
    warnings: Vec<Value>,
) -> Value {
    json!({
        "schema_version": "1.0",
        "command": command,
        "file": {
            "path": file_path,
            "format": file_format,
        },
        "target": target,
        "meta": meta,
        "data": data,
        "warnings": warnings,
    })
}

/// Build a minimal target object for workbook-level queries.
pub fn target_workbook() -> Value {
    json!({})
}

/// Build a target object for sheet-level queries.
pub fn target_sheet(sheet_name: &str, sheet_index: usize) -> Value {
    json!({
        "sheet": sheet_name,
        "sheet_index": sheet_index,
    })
}

/// Build a target object for range-level queries.
pub fn target_range(sheet_name: &str, sheet_index: usize, range: &str) -> Value {
    json!({
        "sheet": sheet_name,
        "sheet_index": sheet_index,
        "range": range,
    })
}

/// Build a target object for cell-level queries.
pub fn target_cell(sheet_name: &str, sheet_index: usize, cell: &str) -> Value {
    json!({
        "sheet": sheet_name,
        "sheet_index": sheet_index,
        "cell": cell,
    })
}