OpenExcelLite

A lightweight, schema-safe Excel (XLSX) generator for .NET using the official OpenXML SDK.
Supports both in-memory and streaming Excel creation — designed for fast, dependency-free exports.

---

✨ Features

• In-memory Excel builder
• Streaming XLSX writer for large datasets (100k–1M rows)
• Table creation with styling
• AutoFilter support
• AutoFit column widths (approx algorithm)
• Date formatting (OADate + style index)
• Automatic header validation and deduplication
• Boolean, numeric, string inference
• Blank row support (in-memory + streaming)
• NEW in v1.2.0 — Hyperlink support (in-memory + streaming)

---

🚀 New in v1.2.0 — Hyperlink Support

OpenExcelLite now supports clickable Excel hyperlinks with:

• Custom display text
• Full ECMA-376 compliant <hyperlinks> + relationship parts
• Works in both in-memory and streaming modes
• No Excel repair warnings
• Fully schema-valid output

✔ Create a hyperlink

s.AddRow("Name", "Website");
s.AddRow("Google", XL.Hyper("https://google.com", "Visit Google"));

✔ Streaming hyperlinks

var bytes = StreamingWorkbookBuilder.Build("Links", w =>
{
    w.WriteRow("Name", "Website");
    w.WriteRow("GitHub", XL.Hyper("https://github.com/livedcode/OpenExcelLite"));
});

---

🚀 New in v1.1.0 — Blank Row Enhancements

✔ AddEmptyRows() — In-Memory Builder

s.AddEmptyRows(3);
s.AddRow("Id", "Name");
s.AddRow(1, "Alex");

✔ Streaming: WriteEmptyRows()

writer.WriteEmptyRows(5);
writer.WriteRow("Id", "Name");

---

📄 Example (In-Memory)

var bytes = new WorkbookBuilder()
    .AddSheet("Demo", s =>
    {
        s.AddEmptyRows(2);
        s.AddRow("Id", "Name", "Active");
        s.AddRow(1, "Alex", true);
        s.AddRow(2, "Brian", false);
        s.AddTable("Employees");
        s.AutoFitColumns();
    })
    .Build();

File.WriteAllBytes("demo.xlsx", bytes);

---

📄 Example (In-Memory Hyperlinks)

var bytes = new WorkbookBuilder()
    .AddSheet("Links", s =>
    {
        s.AddRow("Name", "Website");
        s.AddRow("Google", XL.Hyper("https://google.com", "Visit Google"));
        s.AddRow("GitHub", XL.Hyper("https://github.com/livedcode/OpenExcelLite"));
    })
    .Build();

File.WriteAllBytes("hyperlinks.xlsx", bytes);

---

📄 Example (Streaming)

var bytes = StreamingWorkbookBuilder.Build("Demo", writer =>
{
    writer.WriteEmptyRows(4);
    writer.WriteRow("Id", "Name");
    writer.WriteRow(1, "Alex");
});

---

📄 Example (Streaming Hyperlinks)

var bytes = StreamingWorkbookBuilder.Build("Links", writer =>
{
    writer.WriteRow("Name", "Website");
    writer.WriteRow("Google", XL.Hyper("https://google.com", "Visit"));
    writer.WriteRow("GitHub", XL.Hyper("https://github.com/livedcode/OpenExcelLite"));
});

File.WriteAllBytes("streaming_links.xlsx", bytes);

---

📌 Hyperlink Behavior

• Display text stored in the cell
• URL stored in hyperlink relationship (.rels)
• Excel renders as a standard clickable hyperlink
• Works in both in-memory & streaming modes
• Fully valid when checked with OpenXML Validator
• No Excel “Repaired Records” alerts

---

📜 License

MIT License (included in package)