XlsxForge 1.1.3

XlsxForge

Modern high-performance XLSX toolkit for .NET using OpenXML

Features

• Export — List<T>, IEnumerable<T>, DataTable, multiple sheets
• Import — XLSX to List<T> with header-based property mapping
• Streaming — 100k+ rows with OpenXmlWriter (SAX mode)
• Styling — Bold headers, fills, borders, date/number formats, wrap text
• Attributes — [ExcelColumn], [ExcelFormat], [IgnoreColumn]
• ASP.NET Core — services.AddXlsxForge() + endpoint extensions
• High Performance — FastMember, RecyclableMemoryStream, async-friendly
• Clean API — No OpenXML types exposed publicly

Installation

dotnet add package XlsxForge

For ASP.NET Core integration:

dotnet add package XlsxForge.AspNetCore

Quick Start

Register Services

builder.Services.AddXlsxForge();

Define Your Model

using XlsxForge.Attributes;

public class Employee
{
    [ExcelColumn("Employee Name", Order = 1)]
    public string Name { get; set; } = string.Empty;

    [ExcelColumn("Email Address", Order = 2)]
    public string Email { get; set; } = string.Empty;

    [ExcelColumn("Hire Date")]
    [ExcelFormat("dd-MM-yyyy")]
    public DateTime HireDate { get; set; }

    [ExcelColumn("Salary")]
    [ExcelFormat("#,##0.00")]
    public decimal Salary { get; set; }

    [IgnoreColumn]
    public string InternalNotes { get; set; } = string.Empty;
}

Export to Excel

var bytes = await exporter.ExportAsync(employees, new ExcelExportOptions
{
    SheetName = "Employees",
    AutoFitColumns = true,
    FreezeHeaderRow = true,
    BoldHeaders = true
});

await File.WriteAllBytesAsync("employees.xlsx", bytes);

Import from Excel

using var stream = File.OpenRead("employees.xlsx");
var employees = await importer.ImportAsync<Employee>(stream);

Multi-Sheet Export

var sheets = new[]
{
    ExcelSheet.Create("Employees", employees),
    ExcelSheet.Create("Departments", departments),
};

var bytes = await exporter.ExportMultiSheetAsync(sheets);

Large Dataset Streaming (100k+ rows)

var largeExporter = serviceProvider.GetRequiredService<LargeFileExporter>();
var bytes = await largeExporter.ExportAsync(hugeDataset, new ExcelExportOptions
{
    SheetName = "BigData"
});

🌐 ASP.NET Core Integration

Minimal API

app.MapGet("/api/export", async (IExcelExporter exporter) =>
{
    var employees = GetEmployees();
    return await exporter.ToExcelResult(employees, "employees-report");
});

Web API Controller

[HttpGet("export")]
public async Task<IActionResult> Export([FromServices] IExcelExporter exporter)
{
    var data = await GetDataAsync();
    var bytes = await exporter.ExportAsync(data);
    return File(bytes, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "report.xlsx");
}

Export Options

Architecture

XlsxForge
├── Interfaces/        → Public API contracts
├── Models/            → Options, sheet, column, cell models
├── Attributes/        → [ExcelColumn], [ExcelFormat], [IgnoreColumn]
├── Mapping/           → Reflection + FastMember property mapping
├── Styling/           → Stylesheet builder (fonts, fills, borders)
├── Exporting/         → Workbook generation orchestrator
├── Importing/         → Workbook reader + type converter
├── Streaming/         → OpenXmlWriter SAX-mode for large files
├── Helpers/           → Cell ref, column name, date conversions
├── Internal/          → RecyclableMemoryStream, TypeAccessor cache
├── Extensions/        → byte[], Stream, DataTable helpers
├── Exceptions/        → Custom exception hierarchy
├── Constants/         → Shared constants
└── DependencyInjection/ → services.AddXlsxForge()

Documentation

• Getting Started
• Exporting Guide
• Importing Guide
• Styling Guide

Testing

dotnet test XlsxForge.slnx

License

MIT © XlsxForge Contributors