SheetKit

A Rust library for reading and writing Excel (.xlsx) files, with Node.js bindings via napi-rs.

한국어 버전은 README.ko.md를 참조하세요.

Warning: SheetKit is experimental. APIs may change without notice. This project is under active development.

Features

• Read/write .xlsx files
• Rust core + Node.js bindings (napi-rs)
• Cell operations (string, number, boolean, date, formula)
• Sheet management (create, delete, rename, copy, active sheet)
• Row/column operations (insert, delete, resize, hide, outline)
• Style system (font, fill, border, alignment, number format, protection)
• 43 chart types with 3D support
• Images (11 formats: PNG, JPEG, GIF, BMP, ICO, TIFF, SVG, EMF, EMZ, WMF, WMZ)
• Conditional formatting (17 rule types)
• Data validation, comments, auto-filter
• Formula evaluation (110+ functions)
• Streaming writer for large datasets
• Merge cells, hyperlinks, freeze/split panes
• Page layout and print settings
• Document properties, workbook/sheet protection
• Pivot tables
• Defined names (named ranges)

Quick Start

Rust:

use sheetkit::{CellValue, Workbook};

fn main() -> sheetkit::Result<()> {
    let mut wb = Workbook::new();
    wb.set_cell_value("Sheet1", "A1", CellValue::String("Hello".into()))?;
    wb.set_cell_value("Sheet1", "B1", CellValue::Number(42.0))?;
    wb.save("output.xlsx")?;
    Ok(())
}

TypeScript:

import { Workbook } from "@sheetkit/node";

const wb = new Workbook();
wb.setCellValue("Sheet1", "A1", "Hello");
wb.setCellValue("Sheet1", "B1", 42);
wb.save("output.xlsx");

Installation

Rust -- use cargo add (recommended):

cargo add sheetkit

Or add to your Cargo.toml:

[dependencies]
sheetkit = "0.4"

View on crates.io

Node.js:

# npm
npm install @sheetkit/node

# yarn
yarn add @sheetkit/node

# pnpm
pnpm add @sheetkit/node

View on npm

Documentation

Documentation Site | Korean (한국어)

See the docs/ folder for documentation source files.

Acknowledgements

SheetKit is heavily inspired by the implementation of Excelize, the Go library for Excel files. This project was built for the Rust and TypeScript projects, and we have great respect and admiration for the work done by the Excelize team and its contributors.

License

MIT OR Apache-2.0