// STRYKE-OFFICE — OFFICE DOCUMENT I/O FOR STRYKE // EXCEL + WORD + POWERPOINT + ODF + PDF

Install

# from a release tarball
s pkg install -g github.com/MenkeTechnologies/stryke-office

# from a local checkout
cd ~/projects/stryke-office
cargo build --release
s pkg install -g .           # cdylib lands in ~/.stryke/store/office@<version>/

# one-liner
make install

This is a library — there is no CLI launcher. The cdylib is dlopened in-process on the first use Office.

Quick start

use Office

# spreadsheet: write xlsx, read back, re-emit as ods
Office::sheet_write("report.xlsx", [
    { name => "Sales", rows => [["product", "units"], ["widget", 120]] },
])
val $sheets = Office::sheet_read("report.xlsx")
Office::sheet_write("report.ods", $sheets)

# document: build a docx from structured blocks
Office::doc_write("memo.docx", [
    { kind => "heading", level => 1, text => "Quarterly Report" },
    { kind => "para", text => "Revenue grew 18%." },
])

# presentation + pdf
Office::slides_write("deck.pptx", [{ title => "Intro", body => ["point one"] }])
Office::pdf_write("out.pdf", ["Line one", "Line two"])

Format matrix

Output format comes from the path extension; override with format => "...". Every raster codec the image crate ships is enabled, so read and write cover the full image list above.

Surface at a glance

The Office namespace exposes 465 public functions across these families. The full reference for each is in the tables below.

Core I/O

Spreadsheet analytics (sheet_*)

175 functions turn a spreadsheet path into a dataframe-style toolkit. Each opens the file, applies the operation, and (when an $output is given) writes the result; the target format is taken from the output extension. A few representative groups:

Rich formatting

Spreadsheet cells and document runs accept styling, not just scalars. A cell can be a scalar or a rich object; a docx block can carry styled runs.

Office::sheet_write("r.xlsx", [{ name => "S", rows => [
    [{ v => "Header", bold => 1, color => "#FF0000", bg => "#FFFF00", align => "center" }],
    [{ v => 42, num_format => "0.00", italic => 1 }],
    [{ f => "=A2*2" }],                       # formula cell
] }])
# cell keys: v|value, f|formula, bold, italic, underline, font, size,
#            color, bg, align (left/center/right), num_format, border

Office::doc_write("r.docx", [
    { kind => "para", align => "center", runs => [
        { text => "Bold ", bold => 1, color => "#0000FF", size => 18 },
        { text => "and italic", italic => 1 },
    ] },
])

Sheet-level structure (xlsx) also supports merges, frozen panes, autofilter, worksheet tables, conditional formatting, data-validation dropdowns, sparklines, notes, embedded images, outline grouping, page setup, defined names, and workbook properties. ODF (ods/odt) and PDF are written unstyled — the lo_odf/lo_core serializers do not expose per-run styling (a documented crate limitation, not faked).

Documents (doc_*) & presentations (slides_*)

PDF (pdf_*)

# inspect a form, then fill it (checkbox takes a bool)
val $f = Office::pdf_form_fields("application.pdf")
Office::pdf_fill_form("application.pdf", {
    "applicant_name" => "Jane Doe",
    "agree_terms"    => \1,
}, output => "application-filled.pdf")

# password-protect with AES-128, allow printing only, then strip it back off
Office::pdf_encrypt("report.pdf", "report-locked.pdf",
    owner_password => "admin", user_password => "view",
    aes => \1, permissions => ["print"])
Office::pdf_decrypt("report-locked.pdf", "report-open.pdf", password => "admin")

Images (img_*) — handle-based, like a PIL Image

Image ops return a numeric handle: open once, transform many times, then img_save / img_close. Geometry-changing ops return a new {handle, width, height, mode}; in-place filters mutate the handle.

val $im = Office::img_open("photo.jpg")
Office::img_resize($im->{handle}, 800, 600, filter => "lanczos3")
Office::img_grayscale($im->{handle})
Office::img_save($im->{handle}, "out.png")   # transcode by extension
Office::img_close($im->{handle})

Charting (chart_*)

Render charts natively (imageproc + the vendored font — no plotters, no system fonts). 60+ types render identically in raster and SVG.

Types include bar/column/stacked, line/area/step/combo, scatter/bubble, pie/donut, histogram, radar, sankey, waterfall, ohlc/candlestick, boxplot, funnel, gauge, heatmap, treemap, sunburst, calendar, plus a ggplot2-style set (density, violin, ecdf, qq, ribbon, jitter, rug, beeswarm, contour, ridgeline, smooth/loess, bin2d, pairs, dendrogram).

for val $spec ([["bar","png"], ["line","jpg"], ["pie","webp"]]) {
    val ($type, $fmt) = @$spec
    val $c = Office::chart_render($type, [{ name => "Sales", data => \@sales }],
                                  title => "Q sales", categories => \@cats)
    Office::img_save($c->{handle}, "out-$type.$fmt")
    Office::img_close($c->{handle})
}

Barcodes & QR codes (barcode_*)

Both produce an image handle, so the result composes with the entire image surface — save, paste onto a label canvas, or embed in a PDF/docx. Generated natively (qrcode + barcoders).

Metadata, media, templates, text & converters

Cell-reference helpers (no workbook)

Pure A1 / R1C1 / range math — no file is opened, so these run standalone.

Troubleshooting

No external binaries

Each format maps to a vendored Rust crate, statically linked: calamine (xlsx/xls read), rust_xlsxwriter (xlsx write), lo_odf (ods/odt/odp write), docx-rs (docx write), zip+quick-xml (OOXML/ODF read + pptx write), and lo_core (PDF read+write, no font files). There is deliberately no soffice call — so there is no generic render-conversion (docx→pdf laid out like Word), which needs a layout engine. You get structured read, structured write, and PDF generation from a content model.

Sibling packages

Part of the stryke package family. Browse the others via the MenkeTechnologiesMeta umbrella repo:

• stryke-arrow — Apache Arrow / Parquet / Feather
• stryke-aws — S3, DynamoDB, SQS, Lambda, STS
• stryke-azure — Blob, Queues, Cosmos DB, Key Vault, Entra
• stryke-clickhouse — ClickHouse
• stryke-demo — live demos for every connector
• stryke-docker — Docker daemon API
• stryke-duckdb — embedded DuckDB SQL engine
• stryke-email — email + campaign client
• stryke-fleet — parallel expect/PTY automation
• stryke-gcp — Cloud Storage, Pub/Sub, Secret Manager, BigQuery, Firestore
• stryke-grpc — reflection-based gRPC client
• stryke-gui — mouse / keyboard / screen / clipboard automation
• stryke-k8s — Kubernetes
• stryke-kafka — Apache Kafka
• stryke-mcpd — MCP servers without a runtime
• stryke-mongo — MongoDB
• stryke-mssql — Microsoft SQL Server
• stryke-mysql — MySQL / MariaDB
• stryke-neo4j — Neo4j graph (Bolt)
• stryke-parquet — Parquet file inspector
• stryke-polars — Polars + ndarray + linalg + FFT
• stryke-postgres — PostgreSQL
• stryke-redis — Redis / Valkey
• stryke-scrape — web scraping / crawling
• stryke-scylla — ScyllaDB / Cassandra
• stryke-search — Elasticsearch / OpenSearch
• stryke-selenium — browser automation (WebDriver)
• stryke-spark — Spark Connect (no JVM)
• stryke-utils — pure-stryke utility belt
• stryke-zmq — ZeroMQ messaging