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

//! Chart generation command handler

use xls_rs::{
    common::validation,
    converter::Converter,
    excel::{ChartConfig, DataChartType, ExcelHandler, WriteOptions},
};
use anyhow::Result;

/// Handle the chart command
///
/// Creates a chart from data and saves it to an Excel file.
pub fn handle_chart(
    input: String,
    output: String,
    chart_type: String,
    title: Option<String>,
    x_column: Option<String>,
    y_column: Option<String>,
) -> Result<()> {
    let converter = Converter::new();
    let data = converter.read_any_data(&input, None)?;

    // Parse chart type
    let chart_type = match chart_type.to_lowercase().as_str() {
        "line" => DataChartType::Line,
        "bar" => DataChartType::Column,
        "column" => DataChartType::Column,
        "pie" => DataChartType::Pie,
        "scatter" => DataChartType::Scatter,
        "area" => DataChartType::Area,
        _ => anyhow::bail!(
            "Unknown chart type: {}. Use: line, bar, pie, scatter, area",
            chart_type
        ),
    };

    // Determine x and y columns
    let x_col = if let Some(col) = x_column {
        find_column_index(&data, &col)?
    } else {
        0 // Default to first column
    };

    let y_col = if let Some(col) = y_column {
        find_column_index(&data, &col)?
    } else {
        1 // Default to second column
    };

    validation::validate_column_index(&data, x_col)?;
    validation::validate_column_index(&data, y_col)?;

    // Create chart configuration
    let _config = ChartConfig {
        chart_type,
        title: Some(title.unwrap_or_else(|| "Chart".to_string())),
        category_column: x_col,
        value_columns: vec![y_col],
        ..Default::default()
    };

    // Write Excel with chart (placeholder - chart integration needs workbook API)
    let handler = ExcelHandler::new();
    let options = WriteOptions::default();

    handler.write_styled(&output, &data, &options)?;
    println!("Created {:?} chart; wrote {}", chart_type, output);

    Ok(())
}

/// Find column index by name or number
fn find_column_index(data: &[Vec<String>], column: &str) -> Result<usize> {
    if data.is_empty() {
        anyhow::bail!("Data is empty");
    }

    let header = &data[0];

    // Try to parse as number first
    if let Ok(index) = column.parse::<usize>() {
        if index == 0 {
            anyhow::bail!("Column indices start from 1");
        }
        return Ok(index - 1);
    }

    // Try to find by name
    header
        .iter()
        .position(|col_name| col_name == column)
        .ok_or_else(|| anyhow::anyhow!("Column '{}' not found", column))
}