RecursiveAI.OneDocument.Spreadsheets 1.0.0

RecursiveAI.OneDocument.Spreadsheets

Read, write, calculate, template and render Word, Excel and PowerPoint documents (OOXML, legacy binary, RTF, ODF) in pure .NET. Not affiliated with Microsoft.

This package is the spreadsheet part of OneDocument (a preview, not yet published). It opens, edits and saves XLSX, XLSM, XLTX, XLSB and Flat OPC workbooks, reads legacy XLS and writes BIFF8 XLS, reads and writes CSV and TSV, streams rows and cells of very large sheets, and calculates: cached values are what you read, opening never recalculates, and Workbook.Recalculate() runs the formulas when you ask.

• Lossless. Parts you did not edit are written back byte-identical. Editing one cell rewrites only its sheet part; unknown row and cell attributes, extLst and mc:AlternateContent survive.
• Compact. Cells live in a columnar, sparse store: about 37 bytes per cell on a workbook with styles, strings and formulas, and about 0 bytes allocated per cell while iterating.
• Streaming. XlsxStreamReader and XlsxStreamWriter work forward-only at constant memory with no allocation per cell. XlsbStreamReader and XlsStreamReader read binary workbooks (.xlsb, .xls) the same way, and Spreadsheet.Read<T> and Office.ExtractText use them.
• Typed rows. Mark a partial class, struct or record with [SpreadsheetRow] and Spreadsheet.Read<T>(path) / Spreadsheet.Write(path, rows) move it to and from XLSX, CSV and TSV in one call, streaming. A source generator that ships in this package writes the binding when you compile, so there is no reflection and it works under trimming and NativeAOT.
• Safe. The format is found from the content, never the extension. Damage is reported as typed defects with cell addresses or part offsets, and resource limits are on by default.
• No setup. Office.Open reaches workbooks as soon as this package is referenced; no registration call is needed.
• Legacy workbooks. Workbook.Open("old.xls") reads Excel 2.0 to 2003 files (BIFF2 to BIFF8) into the same model, with a loss report (Workbook.ImportLoss); Office.Convert("old.xls", "new.xlsx") is one line. See docs/xls.md.
• Excel's number formats (TEXT and cell display, 14 locales) are a shared service in the core package.

using RecursiveAI.OneDocument.Spreadsheets;
using RecursiveAI.OneDocument.Spreadsheets.Streaming;

[SpreadsheetRow(Sheet = "Orders")]
public partial record Order(int Id, string Customer, decimal Total);

Spreadsheet.Write("orders.xlsx", orders);                       // or .csv, .tsv
foreach (Order o in Spreadsheet.Read<Order>("orders.xlsx")) { }  // lazy, streaming

using var wb = Workbook.Open("sales.xlsx");
wb.Sheets[0]["B2"].SetNumber(1200);
wb.Save();                                    // atomic replace; only the edited sheet part changes

using XlsxStreamReader book = XlsxStreamReader.Open("big.xlsx");
using SheetCursor sheet = book.OpenSheet(0);
while (sheet.ReadRow())
{
    while (sheet.ReadCell())
    {
        if (sheet.Kind == CellValueKind.Number) { total += sheet.Number; }
    }
}

See the repository for the support table and measurements, and the changelog.

Licensed MIT OR Apache-2.0, © Recursive AI, LLC. Not affiliated with Microsoft or with any other product or company named OneDocument.