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

//! Handler registry for unified file format handling (DRY, KISS, SOC)

use crate::columnar::{AvroHandler, ParquetHandler};
use crate::csv_handler::CsvHandler;
use crate::excel::ExcelHandler;
use crate::format_detector::DefaultFormatDetector;
use crate::google_sheets::GoogleSheetsHandler;
use crate::traits::FormatDetector;
use crate::traits::{DataReader, DataWriteOptions, DataWriter, FileHandler};
use anyhow::Result;

/// Registry that manages file handlers by format
pub struct HandlerRegistry {
    format_detector: DefaultFormatDetector,
}

impl HandlerRegistry {
    pub fn new() -> Self {
        Self {
            format_detector: DefaultFormatDetector::new(),
        }
    }

    /// Get a handler for reading a file based on its format
    pub fn get_reader(&self, path: &str) -> Result<Box<dyn DataReader>> {
        let format = self.format_detector.detect_format(path)?;

        match format.as_str() {
            "csv" => Ok(Box::new(CsvHandler::new())),
            "xlsx" | "xls" | "ods" => Ok(Box::new(ExcelHandler::new())),
            "parquet" => Ok(Box::new(ParquetHandler::new())),
            "avro" => Ok(Box::new(AvroHandler::new())),
            "gsheet" => Ok(Box::new(GoogleSheetsHandler::new())),
            _ => anyhow::bail!("Unsupported format: {format}"),
        }
    }

    /// Get a handler for writing a file based on its format
    pub fn get_writer(&self, path: &str) -> Result<Box<dyn DataWriter>> {
        let format = self.format_detector.detect_format(path)?;

        match format.as_str() {
            "csv" => Ok(Box::new(CsvHandler::new())),
            "xlsx" | "xls" | "ods" => Ok(Box::new(ExcelHandler::new())),
            "parquet" => Ok(Box::new(ParquetHandler::new())),
            "avro" => Ok(Box::new(AvroHandler::new())),
            "gsheet" => Ok(Box::new(GoogleSheetsHandler::new())),
            _ => anyhow::bail!("Unsupported format: {format}"),
        }
    }

    /// Get a file handler (both read and write)
    pub fn get_handler(&self, path: &str) -> Result<Box<dyn FileHandler>> {
        let format = self.format_detector.detect_format(path)?;

        match format.as_str() {
            "csv" => Ok(Box::new(CsvHandler::new())),
            "parquet" => Ok(Box::new(ParquetHandler::new())),
            "avro" => Ok(Box::new(AvroHandler::new())),
            "gsheet" => Ok(Box::new(GoogleSheetsHandler::new())),
            _ => anyhow::bail!("Unsupported format: {format}"),
        }
    }

    /// Read data from any supported format
    pub fn read(&self, path: &str) -> Result<Vec<Vec<String>>> {
        let reader = self.get_reader(path)?;
        reader.read(path)
    }

    /// Write data to any supported format
    pub fn write(&self, path: &str, data: &[Vec<String>], options: DataWriteOptions) -> Result<()> {
        let writer = self.get_writer(path)?;
        writer.write(path, data, options)
    }
}