Working with ODS in Rust

Updated Oct 28, 2026

OpenDocument Spreadsheet (ODS) file handling with sheet selection, advanced header processing, and high-performance data operations.

Installation

cargo add --git https://github.com/datisthq/fairspec fairspec
cargo add serde_json

Getting Started

ODS format is handled by the XLSX plugin, which provides:

load_xlsx_table - Load ODS files into tables
save_xlsx_table - Save tables to ODS files
XlsxPlugin - Plugin for framework integration

For example:

use fairspec::fairspec_table::{LoadTableOptions, load_xlsx_table};
use serde_json::json;

let resource = serde_json::from_value(json!({"data": "table.ods"}))?;
let table = load_xlsx_table(&resource, &LoadTableOptions::default())?;
// the column types will be automatically inferred

Basic Usage

Loading ODS Files

use fairspec::fairspec_table::{LoadTableOptions, load_xlsx_table};
use serde_json::json;

let options = LoadTableOptions::default();

// Load a simple ODS file
let resource = serde_json::from_value(json!({"data": "data.ods"}))?;
let table = load_xlsx_table(&resource, &options)?;

// Load with custom format (specify sheet)
let resource = serde_json::from_value(json!({
    "data": "data.ods",
    "fileDialect": {"format": "ods", "sheetName": "Sheet2"},
}))?;
let table = load_xlsx_table(&resource, &options)?;

// Load multiple ODS files (concatenated)
let resource = serde_json::from_value(json!({"data": ["file1.ods", "file2.ods"]}))?;
let table = load_xlsx_table(&resource, &options)?;

Saving ODS Files

use fairspec::fairspec_table::{SaveTableOptions, save_xlsx_table};
use serde_json::json;

// Save with default options
save_xlsx_table(table.clone(), &SaveTableOptions {
    path: "output.ods".into(),
    ..Default::default()
})?;

// Save with custom sheet name
save_xlsx_table(table, &SaveTableOptions {
    path: "output.ods".into(),
    file_dialect: Some(serde_json::from_value(json!({
        "format": "ods",
        "sheetName": "Data",
    }))?),
    overwrite: Some(true),
    ..Default::default()
})?;

Advanced Features

Sheet Selection

use fairspec::fairspec_table::{LoadTableOptions, load_xlsx_table};
use serde_json::json;

// Select by sheet number (1-indexed)
let resource = serde_json::from_value(json!({
    "data": "workbook.ods",
    "fileDialect": {"format": "ods", "sheetNumber": 2},
}))?;
let table = load_xlsx_table(&resource, &LoadTableOptions::default())?;

// Select by sheet name
let resource = serde_json::from_value(json!({
    "data": "workbook.ods",
    "fileDialect": {"format": "ods", "sheetName": "Sales Data"},
}))?;
let table = load_xlsx_table(&resource, &LoadTableOptions::default())?;

Multi-Header Row Processing

use fairspec::fairspec_table::{LoadTableOptions, load_xlsx_table};
use serde_json::json;

// ODS with multiple header rows
let resource = serde_json::from_value(json!({
    "data": "multi-header.ods",
    "fileDialect": {"format": "ods", "headerRows": [1, 2], "headerJoin": "_"},
}))?;
let table = load_xlsx_table(&resource, &LoadTableOptions::default())?;
// Resulting columns: ["Year_Quarter", "2023_Q1", "2023_Q2", "2024_Q1", "2024_Q2"]

Comment Row Handling

use fairspec::fairspec_table::{LoadTableOptions, load_xlsx_table};
use serde_json::json;

// Skip specific comment rows
let resource = serde_json::from_value(json!({
    "data": "with-comments.ods",
    "fileDialect": {"format": "ods", "commentRows": [1, 2], "headerRows": [3]},
}))?;
let table = load_xlsx_table(&resource, &LoadTableOptions::default())?;

// Skip rows with comment prefix
let resource = serde_json::from_value(json!({
    "data": "data.ods",
    "fileDialect": {"format": "ods", "commentPrefix": "#", "headerRows": [1]},
}))?;
let table = load_xlsx_table(&resource, &LoadTableOptions::default())?;

Remote File Loading

use fairspec::fairspec_table::{LoadTableOptions, load_xlsx_table};
use serde_json::json;

// Load from URL
let resource = serde_json::from_value(json!({"data": "https://example.com/data.ods"}))?;
let table = load_xlsx_table(&resource, &LoadTableOptions::default())?;

// Load multiple remote files
let resource = serde_json::from_value(json!({
    "data": [
        "https://api.example.com/data-2023.ods",
        "https://api.example.com/data-2024.ods",
    ],
}))?;
let table = load_xlsx_table(&resource, &LoadTableOptions::default())?;

Column Names

The n-th name names the n-th column. A sheet with more columns than names fails to load; names past its last column add columns that are empty in every row.

use fairspec::fairspec_table::{LoadTableOptions, load_xlsx_table};
use serde_json::json;

// Name the three columns of the sheet
let resource = serde_json::from_value(json!({
    "data": "data.ods",
    "fileDialect": {"format": "ods", "columnNames": ["name", "age", "city"]},
}))?;
let table = load_xlsx_table(&resource, &LoadTableOptions::default())?;