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

//! Output format options for the read command

use anyhow::Result;
use clap::ValueEnum;

/// Output format for read command
///
/// Determines how data is displayed when using the read command.
#[derive(Debug, Clone, Copy, Default, ValueEnum)]
pub enum OutputFormat {
    /// CSV format (comma-separated values)
    #[default]
    Csv,

    /// JSON format (array of objects)
    Json,

    /// JSON Lines / NDJSON (one JSON object per line, streaming-friendly)
    Jsonl,

    /// Markdown table format
    Markdown,
}

impl OutputFormat {
    /// Parse values allowed in `default_format` (config) or CLI strings.
    pub fn from_config_str(s: &str) -> Option<Self> {
        match s.trim().to_ascii_lowercase().as_str() {
            "csv" => Some(Self::Csv),
            "json" => Some(Self::Json),
            "jsonl" | "ndjson" => Some(Self::Jsonl),
            "markdown" | "md" => Some(Self::Markdown),
            _ => None,
        }
    }

    /// If `explicit` is set, use it; otherwise `default_format` from config, else CSV.
    pub fn resolve_for_read(explicit: Option<Self>) -> Result<Self> {
        if let Some(f) = explicit {
            return Ok(f);
        }
        let cfg = crate::cli::runtime::load_cli_config()?;
        if let Some(ref s) = cfg.default_format {
            if let Some(f) = Self::from_config_str(s) {
                return Ok(f);
            }
            anyhow::bail!(
                "Invalid default_format in config: {:?}. Use csv, json, jsonl, or markdown.",
                s
            );
        }
        Ok(Self::Csv)
    }

    /// Get the file extension for this format
    pub fn extension(&self) -> &'static str {
        match self {
            OutputFormat::Csv => "csv",
            OutputFormat::Json => "json",
            OutputFormat::Jsonl => "jsonl",
            OutputFormat::Markdown => "md",
        }
    }

    /// Get the MIME type for this format
    pub fn mime_type(&self) -> &'static str {
        match self {
            OutputFormat::Csv => "text/csv",
            OutputFormat::Json => "application/json",
            OutputFormat::Jsonl => "application/x-ndjson",
            OutputFormat::Markdown => "text/markdown",
        }
    }
}

impl std::fmt::Display for OutputFormat {
    fn fmt(&self, f: &mut std::fmt::Formatter<'_>) -> std::fmt::Result {
        match self {
            OutputFormat::Csv => write!(f, "csv"),
            OutputFormat::Json => write!(f, "json"),
            OutputFormat::Jsonl => write!(f, "jsonl"),
            OutputFormat::Markdown => write!(f, "markdown"),
        }
    }
}