DRIT.Spreadsheet
Pure-managed, cross-platform .NET workbook automation. Create, read, calculate, edit, protect, sign, convert, and export spreadsheet documents without requiring Microsoft Excel or Office Interop.
When DRIT.Spreadsheet fits
Use it in reporting services, data-import pipelines, finance and operations tools, document-generation systems, and server applications that need Excel-compatible workbooks without automating a desktop application.
Capabilities
- Data and formulas: typed values, shared and array formulas, circular-reference detection, iterative calculation, sorting, AutoFilter, data validation, DataTable, JSON, CSV, TSV, and Markdown workflows.
- Reporting: number formats, fonts, borders, fills, rich text, conditional formatting, themes, AutoFit, grouping, page setup, headers, footers, and page breaks.
- Workbook structures: worksheets, tables, pivot tables, slicers, defined names, hyperlinks, comments, threaded comments, custom XML, OLE objects, shapes, pictures, form controls, and sparklines.
- Protection and export: Agile AES-256 encryption, workbook/worksheet protection, XAdES-BES signatures, VBA preservation/editing, PDF, image, HTML, and Markdown export.
Format direction
| Format | Direction | Context |
|---|---|---|
| XLSX / XLSB / CSV / TSV | Read / write | Primary workflows |
| XLS | Read / preservation | Legacy compatibility |
| HTML / JSON | Read / write | Import/export |
| PDF / images / EMF | Write | Rendering/export |
Platform and quick start
Targets net48, netstandard2.0, and net6.0. Excel and Office Interop are not required. PDF/image output uses DRIT.Pdf and DRIT.Drawing.
dotnet add package DRIT.Spreadsheet --version 26.9.1379
var workbook = new Workbook();
var sheet = workbook.Worksheets[0];
sheet.Cells["A1"].Value = "Product";
sheet.Cells["B1"].Value = "Revenue";
sheet.GetRange("A1:B1").Font.Bold = true;
workbook.SaveAs("output.xlsx");Choose your next step
- Install the package from NuGet
- Read the AddAreaChart example
- Browse the examples/documentation repository
- Downloads, licensing, and purchase options
Commercial product context: the public repository contains examples and documentation, not the commercial product source or an MIT license. Verify the PDF rendering license and deployment terms for production export workflows.