OpenExcelLite.Net48 v1.0.0 – First Stable Release

🚀 OpenExcelLite.Net48 v1.0.0 – First Stable Release

This is the first official stable release of OpenExcelLite.Net48, a lightweight Excel (XLSX) generator designed specifically for .NET Framework 4.8 / 4.8.1, powered by OpenXML 3.3.0 and inspired by the API style of OpenExcelLite (modern .NET).

No Excel interop. No COM. No dependencies.
Just clean, fast, developer-friendly Excel output.

✨ What’s New in v1.0.0
🧩 Core Features

Multi-sheet support
Create as many sheets as needed using AddSheet("Name").

Row operations

AddRow()

AddRows()

AddEmptyRows()

Schema-safe design
Ensures consistent column counts across rows.

HyperlinkCell
Add clickable links inside Excel cells.

🎨 Presentation Features

Auto column width based on cell content

Header styling (bold + background fill)

Freeze panes: easily freeze top rows or left columns

sheet.FreezePanes(1); // Freeze header row
sheet.FreezePanes(1, 1); // Freeze both row + column

📅 Data Type Handling

Dates stored as OADate doubles (Excel-native)

Numeric cells (int, decimal, double, etc.)

Boolean cells

Shared String Table for efficient text storage

💾 Export Options

Save to disk:

workbook.SaveToFile("output.xlsx");

Save to any stream

Export fully in-memory via ToArray()

📁 Samples Included

Sample project demonstrates:

Simple Excel generation

Hyperlinks

Empty rows (before/after header)

Multi-sheet examples

Multi-sheet hyperlinks

10-sheet stress test

In-memory usage

(Exactly matching the structure of OpenExcelLite 1.3.0 samples.)

🧪 Test Suite

Complete xUnit tests included:

Multi-sheet validation

Hyperlinks + relationships

Auto column width

Date cells

Freeze panes

Header formatting

📦 Installation
NuGet

Install-Package OpenExcelLite.Net48

Supports:

net48

net481

🛠 Minimum Requirements

.NET Framework 4.8 or 4.8.1

OpenXML SDK 3.3.0

C# 7.3 or higher

Visual Studio 2019 or 2022

🔧 Limitations (By Design)

📄 License

Released under the MIT License.

🎉 Thank You

This release brings the modern OpenExcelLite experience to legacy .NET Framework 4.8 applications — clean, fast, and dependency-free.

If you find this useful, please ⭐ star the repository!