Spreadsheet files, with clear boundaries.

Read and write a documented subset of XLSX and ODS in Ruby. Lesath preserves supported cells and rejects features it cannot keep intact.

Workbook exchangesupported cells
Example spreadsheet with text and numeric cells
ItemAmount
Tea12.50
Coffee8.00
Water4.25
sales.xlsxsales.ods
Supported scalar cells can move between both formats. Formula languages are not translated.

Predictable by design.

Interchange without quietly changing the workbook you meant to keep.

Keep the essentials

Multiple ordered sheets, sparse cells, strings, finite numbers, and booleans.

Know what is unsupported

Styles, charts, merged cells, and other unsupported features fail on import rather than disappear.

Handle formulas honestly

Store formula text and a cached value in the same format. Lesath does not calculate or translate formulas.

Start with the gem.

Requires CRuby 3.2 or newer. The README includes the workbook API and exact format limits.

gem install lesath
Read the quick start