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

//! Format detection for file types

use crate::traits::FormatDetector;
use anyhow::Result;

/// Default format detector implementation
pub struct DefaultFormatDetector;

impl DefaultFormatDetector {
    pub fn new() -> Self {
        Self
    }
}

impl FormatDetector for DefaultFormatDetector {
    fn detect_format(&self, path: &str) -> Result<String> {
        // Check for Google Sheets URLs or IDs first
        if path.starts_with("gsheet://")
            || path.starts_with("https://docs.google.com/spreadsheets/")
            || (path.len() >= 44
                && path
                    .chars()
                    .all(|c| c.is_alphanumeric() || c == '-' || c == '_'))
        {
            return Ok("gsheet".to_string());
        }

        // Fall back to file extension detection
        path.split('.')
            .last()
            .map(|s| s.to_lowercase())
            .ok_or_else(|| anyhow::anyhow!("No file extension found in: {}", path))
    }

    fn is_supported(&self, format: &str) -> bool {
        matches!(
            format.to_lowercase().as_str(),
            "csv" | "xlsx" | "xls" | "ods" | "parquet" | "avro" | "gsheet"
        )
    }

    fn supported_formats(&self) -> Vec<String> {
        vec![
            "csv".to_string(),
            "xlsx".to_string(),
            "xls".to_string(),
            "ods".to_string(),
            "parquet".to_string(),
            "avro".to_string(),
            "gsheet".to_string(),
        ]
    }
}