xls-rs 0.1.1

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

use anyhow::Result;

/// Cell style configuration
#[derive(Debug, Clone, Default)]
pub struct CellStyle {
    /// Bold text
    pub bold: bool,
    /// Italic text
    pub italic: bool,
    /// Background color (hex without #, e.g., "4472C4")
    pub bg_color: Option<String>,
    /// Font color (hex without #)
    pub font_color: Option<String>,
    /// Font size
    pub font_size: Option<f64>,
    /// Border style
    pub border: bool,
    /// Horizontal alignment
    pub align: Option<String>,
    /// Number format (e.g., "0.00", "#,##0", "yyyy-mm-dd")
    pub number_format: Option<String>,
}

impl CellStyle {
    pub fn header() -> Self {
        Self {
            bold: true,
            bg_color: Some("4472C4".to_string()),
            font_color: Some("FFFFFF".to_string()),
            border: true,
            align: Some("center".to_string()),
            ..Default::default()
        }
    }

    /// Parse hex color string to RGB color
    pub fn parse_hex_color(hex: &str) -> Result<u32> {
        let hex = hex.trim_start_matches('#');
        if hex.len() != 6 {
            anyhow::bail!("Invalid hex color: {}", hex);
        }
        let r = u8::from_str_radix(&hex[0..2], 16)?;
        let g = u8::from_str_radix(&hex[2..4], 16)?;
        let b = u8::from_str_radix(&hex[4..6], 16)?;
        Ok(r as u32 * 0x10000 + g as u32 * 0x100 + b as u32)
    }
}

/// Options for styled Excel writing
#[derive(Debug, Clone)]
pub struct WriteOptions {
    /// Sheet name
    pub sheet_name: Option<String>,
    /// Apply header styling to first row
    pub style_header: bool,
    /// Header style
    pub header_style: CellStyle,
    /// Column-specific styles (by index)
    pub column_styles: Option<std::collections::HashMap<usize, CellStyle>>,
    /// Freeze first row
    pub freeze_header: bool,
    /// Enable auto-filter
    pub auto_filter: bool,
    /// Auto-fit column widths
    pub auto_fit: bool,
}

impl Default for WriteOptions {
    fn default() -> Self {
        Self {
            sheet_name: None,
            style_header: true,
            header_style: CellStyle::header(),
            column_styles: None,
            freeze_header: false,
            auto_filter: false,
            auto_fit: true,
        }
    }
}