The Complete Production SOP: How to Deploy and Run Calamine Rust Ultra-Fast Excel Reader in Autonomous AI Agents

---
name: "calamine-rust-fast-excel-reader"
description: "Read massive Excel and ODS spreadsheets at native Rust speed with Calamine."
metadata:
  author: "tafia"
  version: "1.0.0"
  runtime_compatibility:
    - "codex"
    - "claude-code"
    - "cursor"
    - "windsurf"
triggers:
  - "read excel fast in rust"
  - "parse xlsb binary excel rust"
  - "stream excel rows calamine"
permissions:
  fs_read: true
  fs_write: "workspace"
  shell_exec: false
  net_access: false
---

[dependencies]
calamine = { version = "0.26", features = ["dates"] }
rayon = "1.10"
anyhow = "1.0"

use calamine::{open_workbook_auto, DataType, Reader, Sheets};
use anyhow::{Context, Result};
use std::path::Path;

pub fn stream_sheet_rows<P: AsRef<Path>>(file_path: P, sheet_name: &str) -> Result<Vec<Vec<String>>> {
    let mut workbook = open_workbook_auto(file_path)
        .context("Failed to open workbook with auto-format detection")?;
    
    let range = workbook.worksheet_range(sheet_name)
        .context(format!("Sheet '{}' not found", sheet_name))?;

    let rows: Vec<Vec<String>> = range.rows().map(|row| {
        row.iter().map(|cell| match cell {
            DataType::Empty => String::new(),
            DataType::String(s) => s.to_string(),
            DataType::Float(f) => f.to_string(),
            DataType::Int(i) => i.to_string(),
            DataType::Bool(b) => b.to_string(),
            DataType::DateTime(dt) => dt.to_string(),
            DataType::Error(e) => format!("ERR: {:?}", e),
        }).collect()
    }).collect();

    Ok(rows)
}